Posted by haggisbasher on 12/25/06 12:10

..
The UK charity I periodically give IT support to has a database with a
client table which currently contains some 600 records but will soon
contain over 10,000.
Currently there are 31 columns in the table; this may increase to 35;
none will contain more than some 2000 characters, few more than 300.
All the appropriate indices have been set up.
Due to sloppy (paper-borne) record-keeping for the last ten years
before computers were introduced, part of the use of the database is
displaying all the data items to allow checking for duplicates and
typos.
For the next few years (until present clients begin to pass away and
new clients are qualified better when adding them) there is no real
alternative to extracting all the records each Query.

The extract Query I'm using is the simple -

$TableName="clients";
$Query="SELECT * FROM $TableName order by blah-blah";
$Result=mysql_db_query ($DBName, $Query, $Link);
while ($Row=mysql_fetch_array ($Result))
{
display each client's data in one line across the screen
}

I'm concerned that this may seem slow when handling the enlarged
number of records. Is there any way to speed this up?

Is MySQL up to the task, or do I need to investigate another RDMS?

If we bought/rented a dedicated server, would that help more than a
new RDMS?

TIA.

[Back to original message]