02-11-2010, 12:23 AM
Quote:These forums are currently closed for maintenance. Please check back later. I've discovered a likely cause of the problems with Mock's load times. When Frank exported the database on the old server, he did not include the table indexes. Unindexed tables are very inefficient, as it then has to read every record in the database PRIOR to the one it is looking for. Often causing the database server to read literally 1000's of records to find the ONE it is looking for. Mock will be returning as soon as I can manually reindex the tables. Thank you.
Everything is always my fault.
