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