RE: How does ebay do it?

My thoughts exactly... I'm not taking this application to to the internet, but it is on our intranet... And I could reasonably have 300 hundred people using it at one time, and maybe 25-30 actually looking up items at one time... and I was just thinking that running through the whole product file every time, was not the most efficient way to do it... Plus, our machine isn't the biggest fish in the pond... It's seems to be always running at ++++ or very close to it...  I wish it was bigger and faster... But it's not...  So I have to program around it...  And as we upgrade to release 4.5 I'll give this soundex option a try... It sounds interesting...

but in the mean time, i'll work on my index program... and as we upgrade our system, i'll replace it with newer database features.

tim

-----Original Message-----
From:   Bob Cozzi [SMTP:bobcozzi@attglobal.net]
Sent:   Friday, March 30, 2001 9:34 AM
To:     MIDRANGE-L@midrange.com
Subject:        RE: How does ebay do it?

You're thinking is in the right direction.

I'm currently building an online store, ala eBay style. Right out of the
gate decided that a keyword search index was going to be necessary. So we
actually parse the item descriptions, name and allow input of a few other
keywords, and build the index from that as items are entered/added to the
system.

Then SQL or SETLL with READE works great and fast. Remember, with online
stores, response time for 1 or two or 10 users is not good enough. You have
to be able to handle 10,000 or more simultaneous users.

Bob Cozzi

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---