if this is something MySQL can do, and if
so, what is the correct syntax? Note that I can't use an
autoincrement column because the IDs aren't being put into
a database.
I've searched through MySQL docs and mailing lists but
couldn't find any mention of this. Any help would be
appreciated.
Matt Fagan
[EMAIL
is that joins between static tables are faster than
joins between dynamic tables (by about 20% for the int
column join). I guess this is what the MySQL manual is
talking about (and other people who posted the same thing
to this thread).
Matt Fagan
[EMAIL PROTECTED]
http://greetings.yahoo.com.au
only.
...
Matt Fagan
http://greetings.yahoo.com.au - Yahoo! Greetings
Send your love online with Yahoo! Greetings - FREE!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
difference between fixed/variable
length rows, as
oppposed to the relative efficiency of CHAR vs. VARCHAR.
Michael
Matt Fagan wrote:
I'm having the same problem. I did a performance test,
and
CHAR columns are significantly faster than VARCHAR (at
least on my platform - MySQL 4.1.1a