Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: Speeding up DBMan-SQL

Quote Reply
Re: Speeding up DBMan-SQL In reply to
I picked up a pretty good book over the weekend (MySQL - by Paul Dubois, New Riders).

I found in this book that "indexing" certain fields really helps speed up the database.

I also found out that thing that was taking the home page so long to display on login was that I am using the "Items_log" to display the last three users to login on the home page. If this is not maintained (remove older log entries) it will continue to read every log entry each time causing a long delay if the log file is long.

Hope this is of help to anyone else experiencing speed problems.

-----------------
donm


Subject Author Views Date
Thread Speeding up DBMan-SQL donm 2452 Dec 30, 2000, 3:54 PM
Thread Re: Speeding up DBMan-SQL
Stealth 2336 Dec 30, 2000, 4:02 PM
Post Re: Speeding up DBMan-SQL
donm 2328 Jan 1, 2001, 11:24 AM