.dump)
the path information produces errors as mysql treats the \ character as
an escaped character.
Removing the path information eliminates the error, but how do I tell
mysqldump not to output the path information?
regards,
nyem
--
MySQL General Mailing List
For list archives: http://
ble (5.00 sec).
How could I optimise it further? I don't mind creating more temp
tables as long as the total execution time is much reduced.
I'm using mysql 4.1.1a-alpha on win2k.
Thanks,
nyem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
l selected by users. Since this will be a web-based report, to
wait for 4 minutes for a response is unacceptable. The actual table has
2 million rows which I guess can take forever to execute.
regards,
nyem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
s4.date
It works fine on small number of rows, but when the table reaches 400 rows
the time it took to execute the query was 16 sec. And my cpu shot up to
100% whenever I populate 1000 rows. What have I done wrong here?
regards,
nyem
--
MySQL General Mailing List
For list archives: h