Go Back   Forum Care Forums > Development Reference Area > MySQL Discussion

Reply
 
LinkBack Thread Tools Display Modes
unwanted insert delay
Old
  (#1)
Tobias Bergmann
Guest
 
Posts: n/a
Default 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?


   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




Contact Us - Forum Care Forums - Archive - Top