Dale wrote: > Hi folks, > [snip] > > What would the best practice be in this case? > > Cheers!
Switch to an RDBMS, period. Your model has grown beyond flat files, and having the full range of SQL relating, sorting, limiting, and selecting will serve you well from the description. It will also scale much, much, much better, especially since you are talking about locking. If you are completely new to SQL/DBs then you might start with MySQL, though I would recommend going with PostgreSQL. http://www.mysql.com http://www.postgresql.org If you haven't started in with DBs I am sure there are good tutorials around, SQL isn't difficult to pickup the basics to get you going. And it is definitely something you will want to learn eventually anyways. Good luck, http://danconia.org -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>