Duncan, Kurt (MCUSA) wrote:
1. Any issues running MySQL Ver. X on Windows 2008 Server?
2. Running a query to list all records of about 2600 records is
very slow and gets an error of Extremely High Work Load, Each record
does contain 1 LONGBLOB containing small voice recording. We are using
the SQL Query Browser and running the same query and same database on a
2000 server 1 gig less memory runs the query in about 15 seconds with no
issues. Is this an issue with MySQL or the 2008 server?
I'm no expert, so I'm not going to comment on the environmental issues.
You'd likely get much more predictable performance if you re-engineer
your tables so that the BLOB is in a separate table from the main
entity, with a FK from there.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
