2006-05-29, 03:37 PM
Sub. Thanks for the fixes with the MVP blank screen and connection problems from yesterdays' Patch for 97.07.
The main reason for my upgrade was SQLite, as I thought for sure it would be faster than MSAccess.
However, doing simple things like displaying the guide is 3 to 4 times slower than MSAccess. Also, the Enhanced Web Admin takes forever to display the guide and doing a show search is quite slow.
I am wondering if there is a need for index optimization on the tables?
The main reason for my upgrade was SQLite, as I thought for sure it would be faster than MSAccess.
However, doing simple things like displaying the guide is 3 to 4 times slower than MSAccess. Also, the Enhanced Web Admin takes forever to display the guide and doing a show search is quite slow.
I am wondering if there is a need for index optimization on the tables?