Mark,
Your suggestion was right on. I found a way to get Zeos to reuse existing connections
and the problem went away. It had been suggested that the problem was caused by
WinXP's writeback cache and I was struggling to figure out how I was going to ever
resolve that one.
Thanks for your
Mark,
Your suggestion certainly sounds plausible. However, I have no control over the
connections with Zeos Database Objects. Even though I open the actual database
connection at the start of the program, it appears that each query forces a new
connect/disconnect. In fact, in perusing through
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at once. As I said, it depends on how one connects to
Hello,
How do you enable logging of slow queries in the MY.INI file under Windows?
Also, does anyone have a reasonably good MY.INI file for a configuration under
Windows 2000 for a local MySQL host?
Thanks,
Dan Cumpian
-
Hello,
I am running MySQL on my local Windows 2000 box and I am experiencing extreme
slowdowns. I have an application that writes query data to MySQL using two,
separate threads. After writing 2000-3000 records, all of a sudden, MySQL goes
to 98% CPU usage and throughput drops to 1 update every 2
Hello,
I am trying to find a way to store the body of a binary NNTP message into
MySQL. However, due to the way lines are encoded, MySQL will not accept the
SQL statement. Does anyone have any ideas on how I should approch this?
Thanks,
Dan Cumpian