[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SQL Differences from In-Memory..?
> Also, someone mentioned a while ago that it's possible to see as much as a 100x speed improvement with a properly indexed database. Any more info on that would be Greatly appreciated.
Hehe, yes, this is very true. We were doing a two table join and doing
a search to get all products with the same name from an mysql server. With
5000 items in the database this query took about 11 seconds. When I went
in and made the product field an index, the query took .11 seconds.
Basically you have to look into what you are keying off in your database
and make that either an index or a key in your database (not always, but
usually). Item code in a products database should probably be your
primary key (unless you don't want it to be unique for some reason, then
just make it an index).
- Ant
--
Anthony Ball ant@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
tel:1.207.657.5078 fax:1.207.657.5048 http://www.maine.com/
