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
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
algorith
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
>
> 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,
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
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)
http://lists.mys
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 cha
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'
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 the
