Re: VCL Win32 forms are dated, will they ever be updated?

Tony Caduto wrote:

Yes, I use Crlab's components and had nothing but trouble until I quit using TMyQuery to issue INSERT commands. Seems TMyQuery keeps TCP connections open and you run out of ports after about 4000 INSERTs. Their documentation leaves a bit to be desired.

If you are doing that many inserts, shouldn't you be using the batch update component instead of the Tmyquery?

It won't keep the connection open if you close it, also MySQL may actually hold on to the connections at the server level for a few minutes.

I have done massive amounts of inserts with the crlab products and never had a problem.

Later,


TMyCommand fixes the problem. Why an INSERT on MyQuery and MyCommand operate differently is beyond me. It took me many weeks (not full time) and the use of low level monitors such as System Internals TCPView to figure out what was going on.

And batch update: I would have considered this if the documentation for this package was better. It is really only a reference as compared to a true user guide.

This still doesn't explain why the native BDS drivers for MySQL are so out-of-date. Perhaps they didn't want them to be up-to-date because that would cut sales of Interbase.

James
.