PEAK XOOPS - Re: Protector missing EXPLAIN in db query? in englishin japanese

Top > XOOPS Modules >Protector >Protector missing EXPLAIN in db query?

Re: Protector missing EXPLAIN in db query?

List posts in the topic

question Re: Protector missing EXPLAIN in db query?

msg# 1.1
depth:
1
Previous post - Next post | Parent - Children.1 | Posted on 2005/5/31 17:28
GIJOE  Gunnery Sergeant   Posts: 4110
hi DaveHaviland.

Quote:
Warning: mysql_query(): Your query requires a full tablescan (table eagle_config, 143 rows affected). Use EXPLAIN to optimize your query. in /modules/protector/class/protector.php on line 44

It is intersting with the setting of your server.

Although it is not so "HEAVY" query, you'd better add KEY to the field of `conf_title` in `config` table by phpMyAdmin etc. if you are using the server.

Votes:1 Average:0.00

Posts tree

  Advanced search

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!