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:
// 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.
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.
In Protector 2.50beta1, protector adds KEY(conf_tile) into `config` table automatically.