hi, i followed this thread and really think that this isn't a locking problem, but a table structure problem.
if there is a column in table with a boolean flag (dealt yes/no) the queries go just looking for rows where dealt=0 (or no). Mathias Selon Duncan Hill <[EMAIL PROTECTED]>: > On Friday 13 May 2005 18:21, Gordon wrote: > > If you can add a table structure why not create a SELECTED table with > > REPORT ID and PERSON ID as the 2 field PRIMARY KEY. > > > > Then you could INSERT IGNORE into this table [with no BEGN/COMMIT] and the > > IGNORE would throw away those already selected. > > Mostly because I've glossed over the exact details of what I'm doing. The > table in question is a reporting table storing a list of IDs (multiple per > key) and things like purge time etc. When the reporting script runs, it > needs to deal with rows that haven't been dealt with before, but not with > rows that are currently being processed by another reporting script that's > already processing rows not dealt with before. > > In theory, no two scripts should ever access the table at the same time - > they > run 15 minutes apart. However, I'd rather not leave it to chance. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]