Sorry, thats a heap table, not a hash table. -----Original Message----- From: Bruce Sandell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 3:44 PM To: [EMAIL PROTECTED] Subject: Indexing hash tables
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 --------------------------------------------------------------------- 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