[Erwin]

Originally posted by Mr_P
Hope you can follow me on this one .

me tester board which is hack free is giving 25-27 queries as standard is that correct and thats with a clean install.

On what page? If it's index.php, it should be less than 20.

Now i take the user table from my boards database (nothing else just the user table to get members name/passwprd/email etc)

Now the queries rise to 91

On what page of your forum? What file are you running to get this query number? Showthread.php?

How is this possible with no hacks installed and is there hope for me to reduce the queries.I dont want all the members to have to re reg but i also dont want all them queries running esp when i aint installed any hacks.

Now remember this is a fresh install and all i want is the info from main board sucah as pass /email

but when i download the user table and run it as a query here is a list of what it runs.

PHP Code:

DROP TABLE IF EXISTS user;
CREATE TABLE user (
   userid int(10) unsigned NOT NULL auto_increment,
   usergroupid smallint(5) unsigned NOT NULL,
   username varchar(50) NOT NULL,
   password varchar(50) NOT NULL,
   email varchar(50) NOT NULL,
   styleid smallint(5) unsigned NOT NULL,
   parentemail varchar(50) NOT NULL,
   coppauser smallint(6) NOT NULL,
   homepage varchar(100) NOT NULL,
   icq varchar(20) NOT NULL,
   aim varchar(20) NOT NULL,
   yahoo varchar(20) NOT NULL,
   signature mediumtext NOT NULL,
   adminemail smallint(6) NOT NULL,
   showemail smallint(6) NOT NULL,
   invisible smallint(6) NOT NULL,
   usertitle varchar(250) NOT NULL,
   customtitle smallint(6) NOT NULL,
   joindate int(10) unsigned NOT NULL,
   cookieuser smallint(6) NOT NULL,
   daysprune smallint(6) NOT NULL,
   lastvisit int(10) unsigned NOT NULL,
   lastactivity int(10) unsigned NOT NULL,
   lastpost int(10) unsigned NOT NULL,
   posts smallint(5) unsigned NOT NULL,
   karma smallint(5) DEFAULT '10' NOT NULL,
   karmaability tinyint(1) DEFAULT '1' NOT NULL,
   karmashow tinyint(1) DEFAULT '1' NOT NULL,
   timezoneoffset varchar(4) NOT NULL,
   emailnotification smallint(6) NOT NULL,
   buddylist mediumtext NOT NULL,
   ignorelist mediumtext NOT NULL,
   pmfolders mediumtext NOT NULL,
   receivepm smallint(6) NOT NULL,
   emailonpm smallint(6) NOT NULL,
   pmpopup smallint(6) NOT NULL,
   pmpopupfull smallint(6) NOT NULL,
   avatarid smallint(6) NOT NULL,
   options smallint(6) DEFAULT '15' NOT NULL,
   birthday date DEFAULT '0000-00-00' NOT NULL,
   maxposts smallint(6) DEFAULT '-1' NOT NULL,
   startofweek smallint(6) DEFAULT '1' NOT NULL,
   ipaddress varchar(20) NOT NULL,
   referrerid int(10) unsigned NOT NULL,
   nosessionhash smallint(6) NOT NULL,
   showleftcolumn smallint(6) DEFAULT '1' NOT NULL,
   starlevel varchar(5) NOT NULL,
   starimg varchar(25) NOT NULL,
   messagepopup tinyint(2) NOT NULL,
   newsfader smallint(6) NOT NULL,
   receivebulletin smallint(5) unsigned DEFAULT '1' NOT NULL,
   inforum smallint(5) unsigned NOT NULL,
   award tinytext NOT NULL,
   startedthreads smallint(5) unsigned NOT NULL,
   startedpubs smallint(5) unsigned NOT NULL,
   forumviewset varchar(250) DEFAULT '219|2:98|2:22|2:252|2:120|2:128|2:61|2:' NOT NULL,
   downloads text NOT NULL,
   storep int(9),
   insurance varchar(20),
   custompageviews int(20) NOT NULL,
   custompage mediumtext NOT NULL,
   custompagename varchar(50) NOT NULL,
   enablecustompage smallint(5) unsigned DEFAULT '1' NOT NULL,
   bmallow smallint(6) NOT NULL,
   bmwarn int(10) unsigned NOT NULL,
   bmban int(10) unsigned NOT NULL,
   bmreported int(6) unsigned NOT NULL,
   timeonline int(10) NOT NULL,
   money smallint(5) unsigned NOT NULL,
   bank int(234) unsigned NOT NULL,
   savemt int(10) unsigned NOT NULL,
   warninglvl int(10) NOT NULL,
   arcadepass int(255) NOT NULL,
   journal smallint(6) NOT NULL,
   PRIMARY KEY (userid),
   KEY usergroupid (usergroupid),
   KEY username (username),
   KEY referrerid (referrerid),
   KEY inforum (inforum),
   KEY referrerid_2 (referrerid)
); 


What can i delete and most importantly how can i delte em before running the query as obviously something here is causing the queries to rise beyond belief.

Cheers for any help.

What do you mean by downloading the user table and running it as a query? Looking at your user table you have lots of custom hack columns, like the journal hack column, custom page column etc. So your database is not a clean install obviously.