[FX.php List] Searching 500,000+ records

[Gjermund Gusland Thorsen]

By limiting output snappyness should not be limited, I have tables
with more than 2'000'000 records.

But do not attempt to display more than 2'000 records at once, THAT
will be slow.

ggt667

On 7/28/06, Bob Patin <bob at patin.com> wrote:
> Hi list folks,
>
> I've got a client for whom I wrote a parser in Visual Basic a few
> years back, which generates HTML pages. In the last 5 years or so,
> his site has approx. 500,000 of these little HTML pages on it (!),
> and I've been trying to talk them into moving the whole thing into a
> database, which is what it should have been from the start (but they
> wouldn't go that route).
>
> Anyway, I'm going to write a new program (I'm going to port their VB
> project into RealBasic for the Mac) that'll take these pages and pull
> them into a text file, which I'll then import into a FM 8.5 database.
>
> Question: can I expect fairly snappy results from a search of 500,000
> + records, assuming they're using a fast dedicated FMSA machine on
> which they're the only database, and also assuming the search is only
> looking at a single field with some sort of numeric ID in it?
>
> Thanks,
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
>
>    CONTACT US VIA INSTANT MESSAGING:
>       AIM or iChat: longterm1954
>       Yahoo: longterm_solutions
>       MSN: tech at longtermsolutions.com
>       ICQ: 159333060
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>