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
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
On Fri, Jan 25, 2002 at 03:44:07PM -0800, Bruce Sandell wrote:
Is the index for a hash table stored on disk or in memory?
You mean for HEAP tables, which used hashed indexes?
I have a hash table that I am constantly adding data to, which means
the index is constantly being updated. If I
]
Subject: Re: Indexing hash tables
On Fri, Jan 25, 2002 at 03:44:07PM -0800, Bruce Sandell wrote:
Is the index for a hash table stored on disk or in memory?
You mean for HEAP tables, which used hashed indexes?
I have a hash table that I am constantly adding data to, which means
the index
On Fri, Jan 25, 2002 at 04:02:23PM -0800, Bruce Sandell wrote:
So does this mean that you should or should not bother using indexes
on a heap table?
You should use an index on a heap table column just like you would for
any other table. It's just that the index isn't a B-Tree like with
From: Karl J. Stubsjoen
Hello,
Can someone explain hash tables or hash indexes and if we can
take advantage
of them in MySQL?
Thanks!
Karl
A few words on a meaty subject...
Hashing is a search method based on an arithmetic or algorithmic
transformation of the key.
Hashing is a means
From: Karl J. Stubsjoen
Imagine: a table with over 200,000 records in it and one of
the fields in
the table is a keywords field. Keywords seperated by commas.
The keyword
field is a collection of keywords that our clients use to identify the
content of their web pages.
What we need
Hello,
Can someone explain hash tables or hash indexes and if we can take advantage
of them in MySQL?
Thanks!
Karl
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hello,
I would like to ask those of you who have used temporary hash tables in
MySQL version 2.23.x if you have encountered any problems, concurs or known
issues. I have been testing it myself and everything sees to working just
fine. Please list your thoughts and comments on temporary hash
Am 22:21 19.03.2001 schrieb Dave Juntgen:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hello,
I would like to ask those of you who have used temporary hash tables in
MySQL version 2.23.x if you have encountered any problems, concurs or known
issues. I have been
10 matches
Mail list logo