Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Speeding up DBMan-SQL

Quote Reply
Speeding up DBMan-SQL
I have my database completely converted over to Dbman-sql now. I have noticed that it seems to take alot longer to login and to search now than when using the flat-file version. We have 2,100 records in the database.

Does anyone have any ideas on how to speed things up a bit?

TIA !

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

Quote Reply
Re: Speeding up DBMan-SQL In reply to
Create additional tables...use foreign keys to connect data between the tables. If you have a bunch of fields with tons of data in them in the same table, then it will take longer to access the data.

Regards,

Eliot Lee
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