Depending on how your application works you might be able to batch the daily updates. Example only do an update every 20 items instead of for each one. Alternatly you could run an update with a join every 10 minutes or so that would update the daily counter.
On Thu, 2 Dec 2004 20:56:45 -0700, Jim McAtee <[EMAIL PROTECTED]> wrote: > I have an application which keeps a table of daily event counters related > to other records in a databse. Since the trackingrecords are kept on a > daily basis new records are created each day for items being referenced. > > In pseudo-code: > > // Check for the existance of daily tracking record > SELECT dailycounterid > FROM dailycounters > WHERE trackingdate = <today> > AND thingid = <somerecordid> > > if <query.recordwasfound> > > // If it exists, increment counter > UPDATE dailycounters > SET count = count + 1 > WHERE dailycounterid = <query.dailycounterid> > > else > > // Otherwise add new record with count of 1 > INSERT INTO dailycounters > (trackingdate, thingid, count) > VALUES > (<today>, <somerecordid>, 1) > > endif > > Is there any way to do this with a single MySQL query instead of a check > followed by either an insert or an update? The MySQL version is 3.2x > using MyISAM tables. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] <a href=http://www.bleated.com>http://www.bleated.com</a> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
