Re: Are queries queued?
Hi Rick,
Apologies for my very delayed reply but I have been away from a PC for quite a while.
"I'm assuming you have some programming language that will let you get the 3 rows selected and build the IN clause needed." - I am using PHP as the programming language, is there a way to pass the result of the first query directly in to the IN () in the second query using MySQL?
"Surely there is more to the application? Will the user be shown the 3 items and do something with them? Will some of them then be changed back to 'available'?" - WHen the user is shown the 3 items their next step will be either purchase or search again. If they do not purchase the 3 items within a 3 minute window they will be automatically available through a separate script.
Based on the table create in my previous post, can you recommend some fields to build an index on that would be beneficial?
Martin
Subject
Written By
Posted
Re: Are queries queued?
June 03, 2009 02:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.