David Brown writes:
> I have a quick lookup table of about 500,000 records.
>
> The table consists of just 3 fields medium int fields, and indexed on just
> one of them - So the records are small, as is the index.
>
> The data won't have any inserts/updates throughout the day, and will be
> built once a day. It's not a problem if the data is lost (server falling
> over), as it can be rebuilt within 5 mins.
>
> I need to get the most screamingly fast performance from the lookup of this
> table (all selects will be "=" matches using the index)
>
> Do I use HEAP tables - benefitting from hashed indexes and always in memory.
>
> Or..
>
> Do I use pack_isam and compress a plain ISAM/MyISAM table ? - benefitting
> from being memory mapped and using less memory (am I right?)
>
> There is oodles of spare memory currently (well, about 256MB spare)
>
> System specs: Dual P3 750, running BSDI 4.0 and 512Mb RAM
Hi!
Use HEAP tables and set a cron job to periodically dump a table (with
CREATE from SELECT ) to MyISAM table.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
