PEAK XOOPS - Protector missing EXPLAIN in db query? 
Protector missing EXPLAIN in db query?
- You cannot open a new topic into this forum
- Guests cannot post into this forum
Previous post
-
Next post
|
Parent
-
Children.1
|
Posted on 2005/5/28 5:40
DaveHaviland
Posts: 1
Posts: 1
I just started getting this at the top of every page:
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
fresh xoops install: 2.0.10 - site isn't even live yet.
protector 2.4
'register_globals' : on
'allow_url_fopen' : on
'XOOPS_DB_PREFIX' : (something) ok
'mainfile.php' : patched ok
'Password for rescue' : ok
I noticed around line 44 you mention:
Quote:
What's the non-performance method?
- I think that's what's holding me up.
Thank you for your time. - great module btw.
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
fresh xoops install: 2.0.10 - site isn't even live yet.
protector 2.4
'register_globals' : on
'allow_url_fopen' : on
'XOOPS_DB_PREFIX' : (something) ok
'mainfile.php' : patched ok
'Password for rescue' : ok
I noticed around line 44 you mention:
Quote:
// Preferences (for performance, I dare to use an irregular method)
What's the non-performance method?
- I think that's what's holding me up.
Thank you for your time. - great module btw.
Votes:2
Average:0.00
GIJOE
Posts: 4110
Posts: 4110
hi DaveHaviland.
Quote:
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.
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
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2005/7/21 18:21
GIJOE
Posts: 4110
Posts: 4110
In Protector 2.50beta1, protector adds KEY(conf_tile) into `config` table automatically.
Votes:1
Average:0.00
Login