On 29-Jun-06, at 6:46 AM, DF Yeah wrote: > my process: > - read from db > - process data (might take as long as few seconds) > - save to db > > i know innodb table is able to lock row record. beside the using > innodb type, can anyone advise me on other possible suggestions. I think you should be able to manually lock/unlock MyIsam tables too. Peace, Shoan. ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator http://www.metastorage.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/