Hi list,
An others question, I am working on projet and i made some test.
I use large databases, some table go up to 1.8g. The problem we have is
wend I try to select data in table whit a group by function and I got "
Copy to tmp table " This function take a long time to execute. I check
on my server for the cpu usage and no hang up, no hang up on hardrive,
the only hang up I have is on memory.
1 Question, the " copy to tmp table " function can optimize to
get faster ?
2 Question, what is the max table I can create in databses ?
because, the way I found to optimize " copy to tmp table " is by
spliting the data in my table in multiple tables to lower the size...But
if I do this way, the table counts on my database can go up to 600
tables :S I don't think is a good way to do this.
Ty for your help and sorry for my english...
Francis !
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
