Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes approximately 7 seconds to
execute this 1000 times (UserName is char[50], and it is indexed). If I
change
PROTECTED]
Sent: Monday, March 10, 2003 1:40 PM
To: [EMAIL PROTECTED]
Subject: Searching on indexed char field...
Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes
At 13:39 -0500 3/10/03, Jason West wrote:
Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes approximately 7 seconds to
execute this 1000 times (UserName is
sql, mysql...
You might also try indexing only a portion of the char[50] index.
index UserName(20), for example...
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
sql, mysql...
oops, forgot the quotes
You might also try indexing only a portion of the char[50] index.
index (UserName(20)), for example...
David
-
Before posting, please check:
http://www.mysql.com/manual.php
If you're indexing all 50 characters, index fewer of them.
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT query to, if anything, go slower...?
I'm probably wrong, though,
On Mon 2003-03-10 at 15:06:05 -0500, [EMAIL PROTECTED] wrote:
If you're indexing all 50 characters, index fewer of them.
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT
Benjamin Pflugmann wrote:
If you have 256MB, the one may fit into memory,
the other may not and therefore requires additional disk reads.
Ah, see.. I hadn't thought of disk reads. I was thinking if you do a
select on a char[50] and the whole field is indexed, wouldn't the search
algorithm
On 10 Mar 2003, at 16:31, Tab Alleman wrote:
I was thinking if you do a select on a char[50] and the whole field
is indexed, wouldn't the search algorithm know exactly where to go
to look for a match, as opposed to - if only the first 20 characters
are indexed - finding all of the possible