Large record numbers

[Raj Dutt <raj@voxel.net>]

******    message to minivend-users from Raj Dutt <raj@voxel.net>     ******

Hi,

I have a client who is switching store fronts and hosting companies.

We've begun to build his store using Minivend. So far I'm pretty
impressed with Minivend - but I'm having some problems with the search
engine. 

Specifically, this client has about 350,000 items (cd's and casettes)
and this could easily grow to 1,000,000 before the year is out.

We've consolidated his database into a flat tab delimited ascii file
with 4 fields (code, price, artist, title).

Understandably, searching this amount of data takes an appreciable
amount of time - when it works. When it does work, perl uses 10M of
memory and uses 90% CPU for a considerable time - something which I am
unhappy about because other clients on the machine suffer.

I'm looking into moving into a more efficient way of doing things.
Namely, MySQL. Today, we should be able to convert the products.asc file
into a MySQL database with a quick perl script w/ DBI.

Now my question is, what's the best way to do this? Totally circumvent
Minivends search engine and go with our own and link directly back to
minivend through product code? (If we do this, what happens to the
shopping basket?)

Suggestions or comments would be welcomed.

Regards,
	Raj Dutt
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list