| unwanted insert delay -
06-04-2007, 07:58 AM
Hi,
I am doing an INSERT (not delayed) query with C API, then starting
another program thread, the thread reads the data that was just inserted
with a SELECT query via C Api.
This worked fine as long as there is just one thread running.
With 2 threats it sometimes happens that the data is not there in that
short time.
Inserting a delay of 1 second before the SELECT query solves the problem
for now.
But actually I don't do an "INSERT DELAYED" and wonder why the data is
not there immediately.
I read that an insert waits until no more selects are running but that
should cause a delay when doing the "INSERT" query
Does the C Api not wait for an insert to be finished? |