Jeff wrote: >What is a good indication that you need to move beyond Access??
When bad things start happening and you see or hear about them, or your ISP demands it to stabilize the server, or -- if you have log access -- you can see a lot of hung threads and slow templates that you can trace down to slow/choked db response, when your server starts throwing L26 and NT #2 errors all over the place and you are thrashing around looking for a culprit. A halfway-decent rule of thumb is (pause while I make it up) when you experience 3 simultaneous, concurrent writes to the db at the same instant, and this happens with frequency. It takes more visitors than you might think to hit such a threshold. Or not... Maybe your app is written in such a way that the db is treated gently, relatively speaking. Maybe if you have problems they are the result of someone else's load (if this is a shared server) so in that scenario your life is much more complicated. Not much of an answer, is it? You've already heard there are no set answers and, really, there aren't. From experience I can say this (only) with certainty: When the time comes where you *must* make a move, you won't need to ask anyone. I think a better question is "When can I afford to make the move?" Don't wait until the site begins to collapse, especially given how tough it is for anyone to give you useful advice on your unique situation. -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
