What are the pros and cons in resizing the MAX index size, from 1024.
- javabuddy
People are conversing... without posting their email or filling up their mail
box. ~~1123957730975~~
roomity.co
Thanks Devananda.. it helped.
- javabuddy.
People are conversing... without posting their email or filling up their mail
box. ~~1123878070408~~
roomity.com http://roomity.com/launch.jsp No sign
javabuddy wrote:
But still I can't get the part where my column size totals to 560, but MySql
complaining that I have exceeded 1024. Did I went anywhere wrong???
Are you sure you've thought your index through correctly and considered how
MySQL will use it? What sort of query would such an in
javabuddy wrote:
Thanks
But still I can't get the part where my column size totals to 560, but MySql
complaining that I have exceeded 1024. Did I went anywhere wrong???
- Gana.
People are con
Thanks
But still I can't get the part where my column size totals to 560, but MySql
complaining that I have exceeded 1024. Did I went anywhere wrong???
- Gana.
People are conversing... without
,
a larger key block size than the default of 1024 bytes is used.
-Original Message-
From: javabuddy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 12, 2005 12:30 PM
To: mysql@lists.mysql.com
Subject: Index - max key length is 1024 bytes
I am trying to create an index with multiple fields.
I am trying to create an index with multiple fields.
The sixe of each of the column is listed and thier sum is 560bytes. But when I
try to create an index with the colums, it complains on the size exceeded 1024
bytes. Below is the query and the size of each..
create index selectTechnologyClubs