Delay on each 'Select' request

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
SARTrack
Posts: 2
Joined: Fri 06 Sep 2013 06:31

Delay on each 'Select' request

Post by SARTrack » Mon 23 Sep 2013 07:07

I have an application which received up to 10 data packets per second, each of which must be either Interted or Updated in one or more Tables.
The big problem is, that each of my Select statements (which I need to retrieve the existing record, before I can Update it), takes always at least 45 miliseconds on my 4-core PC.
This is regardless if there is any data returned, or if the SQL Database table is completely empty of has 1000 records in it.

I run MySQL 5.1, and my program on the same PC.
Loadlevels are low.

There is just that huge 45 milisecond delay on each Select. What is the cause of this? I cannot use the system with these huge delays.

Thanks, Bart

AndreyZ

Re: Delay on each 'Select' request

Post by AndreyZ » Mon 23 Sep 2013 13:22

Please specify the method (a code example) which you use to detect a delay in executing of SELECT statements.

Post Reply