Dana Tierney wrote: >very low-traffic = maybe 2-3 records added a day max. The number of records >will probably never exceed 1000.
Access will do fine. >Relatively high traffic = I don't know, 5- >6 simultaneous users, up to 1000 records updated a day. The number of >records could conceivably get very high in this second case. I am trying to >design so that only simple queries are required in both cases. 1000 updates in 8 business hours is 2 updates per minute. Access should be able to handle that, don't you think :-) FWIW, I have recently suggested some people we host to start thinking about some different solution as Access because they routinely got over 20 queries per second, and they topped at 80 per second. The solution they choose wasn't even upgrading, but query caching. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
