Re: SQL performance

[Birgitt Funk <birgitt@minivend.com>]

******    message to minivend-users from Birgitt Funk <birgitt@minivend.com>     ******



Quoting mikeh@minivend.com (mikeh@minivend.com):
>> ******    message to minivend-users from mikeh@minivend.com     ******
>>

>> That gives me an INSTANTANEOUS return on a 15,550 record database.

>> This gives fast named-field access -- case closed. I didn't think my
>> SQL stuff was THAT bad.

Hallelujah !!! 8-)



[snip]


>> using an SQL database it is YOUR responsibility to index the fields --
>> if MiniVend is taking literally FOREVER to return stuff that tells me
>> you didn't index your 'code' field. If you are not indexing at least
>> the 'code' field, then the results are on your head. If you want
>> fast searches, you must also index the rest of the fields you might
>> be searching.


> You go Mike!

> You are an impressive person with your committment to MiniVend. Is there
> an O'Reilly book forthcoming on MiniVend? I heard there was so I figure
> I should ask someone who can verify this.

> thx,
> dk smith

If that would true, I am going to scratch my last pennies, open up my
site again with at least 800,000 titles in a) .gdbm propduct tables,
b.) in an oracle db and c.) in a MySQL db all on Linux of course.

May be that will prove MiniVend and Mike right.

I would be so happy if that were true ! I would give away the book 
(if it is O'Reilly) to everyone, who can prove he uses MV on his
site, at my purchase price as a bookseller.

Happy MiniVending, Happy MaxiSearching !

Birgitt Funk, 

an O'Reilly fan, a book addict, a MiniVend admirer, a woman
always lost in open source code ... (for now).

-
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