Bob Wright wrote: > Hi Kym, thanks for the reply. > > Very good question. The criteria is really "No Database". There is more > detailed and specific language than that, but it pretty much sums it up. > > As you pointed out, a filesystem is certainly a database, of sorts. I have > been pondering it. It seems a bit messy though. Still, it is my fall-back > plan, if I can't get find a flat file solution. But, it is not my preference. > > We expect not more than ten thousand entries. Likely not more than a few > thousand.
In that case the structure-in-memory is quite viable. > > I would not want to risk keeping the data in memory, with periodic writes to > disc. Not with this project. Hah! what do you think a database server does? We use the struct > WDDX database for our stats engines with complete success. If the hit rate is not too ridiculous you write to disk as soon as the structure is updated, for our stats engine we limit it to once a second to stop the situation getting too frantic but you only need to write when there is an update so how often is the database going to be written to? Remember a flat-file database via ODBC is doing exactly the same thing. And its a "database" where do you draw the line, when is it a database and when is it not. A database is a collection of data, nothing more.... -- Yours, Kym Kovan mbcomms.net.au ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
