Hi!
Thanks, this was what I was wondering.
Cheers,
--Brian
On Apr 27, 2009, at 1:10 PM, Ronald Bradford
<[email protected]> wrote:
I think from memory at eBay we used BTREE for at least one index.
The use case was:
PK insert/update of data, 20k record of cached data per user.
Range delete of stale data by last_updated_date (e.g. older then 20
mins)
Given the volume of data, like 400,000 rows per memory table per
server, the lock time on the range query was still like death to
performance but better then hash.
Of course this is an extreme case, how many use memory engine for such
high volume of transactions.
Regards
Ronald
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
