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.