Is the index for a hash table stored on disk or in memory?  I have a hash
table that I am constantly adding data to, which means the index is
constantly being updated.  If I keep the size of the key buffer sufficiently
large, will the new index values be there upon creation, or not until they
are read from disk?  I would like to avoid having to read from the disk for
every query that uses an index.

Any input or advice would be greatly appreciated.

Thanks,
Bruce


---------------------------------------------------------------------
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

Reply via email to