Re: [Tikiwiki-devel] reducing or caching mysql queries

[Anders K. <and...@ya...>]

The below explains why tikiwiki is SLOOOOW when your
MySQL database is mounted over NFS. I'm going to have
to move my MySQL database to the webservers' local
drive until wiki get's faster/smarter/better.
I get page generation times of around 20 seconds
regularly. Depending on NFS traffic, I get as fast as
2 seconds, and as slow as 140 seconds! :D

-anders

--- Doug Holton <et...@ed...> wrote:
> I am using the ADODB PEAR wrapper, and so I added
> this line to 
> tiki-db.php after the DB::connect($dsn) line:
> $dbTiki->debug = true;
> 
> And it shows that there are over 30 MySQL queries to
> load the default 
> page. Anyway some of these can be reduced into fewer
> queries or cached?
> 
> (mysql): select permName,type, permDesc from
> users_permissions order by 
> permName desc limit 0,-1
> (mysql): select count(*) from users_permissions
> (mysql): select userId from users_users where
> login=''
> (mysql): select groupName from users_usergroups
> where userId=''
> (mysql): select permName from users_grouppermissions
> where 
> groupName='Anonymous'
> (mysql): replace into
> tiki_sessions(sessionId,timestamp) 
>
values('3b2eae2358abcdad59dff5dea412e77a',1039469697)
> (mysql): delete from tiki_sessions where
> timestamp<1039469397
> (mysql): select value from tiki_preferences where
> name='popupLinks'
> (mysql): select value from tiki_preferences where
> name='anonCanEdit'
> (mysql): select value from tiki_preferences where
> name='modallgroups'
> (mysql): select value from tiki_preferences where
> name='tikiIndex'
> (mysql): select value from tiki_preferences where
> name='cachepages'
> (mysql): select value from tiki_preferences where
> name='cacheimages'
> (mysql): select value from tiki_preferences where
> name='allowRegister'
> (mysql): select value from tiki_preferences where
> name='useRegisterPasscode'
> (mysql): select value from tiki_preferences where
> name='validateUsers'
> (mysql): select value from tiki_preferences where
> name='forgotPass'
> (mysql): select value from tiki_preferences where
> name='title'
> (mysql): select value from tiki_preferences where
> name='maxRecords'
> (mysql): select value from tiki_preferences where
> name='maxArticles'
> (mysql): select name,value from tiki_preferences
> (mysql): select value from tiki_preferences where
> name='style'
> (mysql): select value from tiki_preferences where
> name='style'
> (mysql): select userId from users_users where
> login=''
> (mysql): select groupName from users_usergroups
> where userId=''
> (mysql): select
> name,title,position,ord,cache_time,rows,groups from 
> tiki_modules where position='l' order by ord asc
> (mysql): select
> name,title,position,ord,cache_time,rows,groups from 
> tiki_modules where position='r' order by ord asc
> (mysql): select count(*) from tiki_pageviews where
> day=1039410000
> (mysql): update tiki_pageviews set
> pageviews=pageviews+1 where 
> day=1039410000
> (mysql): select pageName from tiki_pages where
> pageName = 'HomePage'
> (mysql): select objectId,objectType from
> users_objectpermissions where 
> objectId='6d7f618fdb6590000b06a03865b40191' and
> objectType='wiki page'
> (mysql): select objectId,objectType from
> users_objectpermissions where 
> objectId='6d7f618fdb6590000b06a03865b40191' and
> objectType='wiki page'
> (mysql): select objectId,objectType from
> users_objectpermissions where 
> objectId='6d7f618fdb6590000b06a03865b40191' and
> objectType='wiki page'
> (mysql): select objectId,objectType from
> users_objectpermissions where 
> objectId='6d7f618fdb6590000b06a03865b40191' and
> objectType='wiki page'
> (mysql): select pageName from tiki_pages where
> pageName = 'HomePage'
> 
> 
> 
>
-------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Tikiwiki-devel mailing list
> Tik...@li...
>
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com