Posted by Stef on 12/25/06 16:55

As stated in the above answer you probably should use LIMIT and divide the
results into pages sorting the records as you please.

A small search form probably would solve a lot too.


<haggisbasher@nerdshack.com> schreef in bericht
news:2cevo2lhd35oalu2tl4mov8c7207uh52b1@4ax.com...
> .
> 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]