Thanks!
>
> >From http://www.mysql.com/doc/en/Bugs.html:
>
> * All string columns, except BLOB and TEXT columns, automatically
>have all trailing spaces removed when retrieved. For CHAR types
>this is okay, and may be regarded as a feature according to ANSI
>SQL92.
mysql> select LENGTH(contact) from options where member='me ';
+-+
| LENGTH(contact) |
+-+
| 2 |
+-+
1 row in set (0.01 sec)
On Wed, Nov 27, 2002 at 03:36:03PM -0600, Paul DuBois wrote:
> At 15:06 -0600 11/27/02, [EMAIL PROTECTED] wrot
member varchar(16) NOT NULL default '',
PRIMARY KEY (member),
On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
> At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
> >Why? (Note the extra space after "me" in the second select)
>
> Hardly enough information to go on. Apparently you'r
Why? (Note the extra space after "me" in the second select)
Your MySQL connection id is 6021 to server version: 3.23.41-log
mysql> select contact from options where member='me';
+-+
| contact |
+-+
| me |
+-+
1 row in set (0.00 sec)
mysql> select contact from option
Hello,
I'm considering building a dual athlon or dual xeon machine.
Which gives better results for mysql queiries using LIKES on
text columns? (under linux)
Currently availabe athlon 2.2 (1.8 ghtz) or Xeon 2.8?
Anyone run any numbrs between the two?
Thanks,
John
---
Dan, thanks for your reply.
When I changed the table definition to use the single index and
the multi-index I reloaded the data from scratch each time.
(I did the trials many times from scratch just to be sure and I
do get consistent results)
I also just did an optimize table as you suggest o
Hello,
Adding an irrelevant second column to an index instead of
just a single column index gives an incredible speedup and
I don't know why!
(server version: 3.23.53a running P133 32 megs ram - not a speedy
machine)
I have a bunch of records with the relevant columns being:
idbigint
Greetings, I am struggling trying to get good performance
using indexes.
I'll spare the details and narrow down the situation. I have about
100,000 rows of data with the following fields:
title - vachar(64)
description - text
state - varchar(2)
priority - int
modified - date
People type in