How Much Can Access Handle
My site currently has about 350 items. I average about 800 visits per day. A few funky things have been happening with my site and everything I am hearing is telling me that access can not handle the amount of traffic and items in my shopping cart. I am being advised to move to SQL. Any thoughts?
www.protectmefirst.com
Your First Choice For Quality Personal Protection Products
openmind posted this at 13:03 — 4th July 2004.
He has: 945 posts
Joined: Aug 2001
There's a couple of schools of thought here. Access is not a production database and is limited in the number of concurrent connections it can suypport. I used to run a site serving 250,000 page views on an Access DB (shudder) and it coped...just
Looking back I should have made the switch to MS SQL sooner but hey you live and learn. If your site is getting weird now on the level of traffic you are getting I would make th switch sooner rather than later. Don't forget that you could also use MySQL if the cost of MS SQL from your host is prohibitive..
m3rajk posted this at 16:15 — 4th July 2004.
They have: 461 posts
Joined: Jul 2003
is access sql compatible?
if not you might want to set up a dev server and migrate everything to using the php pear db so that you can interact with any sql. or to a specific sql if you would like.
and then move things over once you have your scripts working.
remeber, it's very easy to make a very small mistake that causes big headaches, so always try to test first.
POSIX. because a stable os that doesn't have memory leaks and isn't buggy is always good.
openmind posted this at 16:17 — 4th July 2004.
He has: 945 posts
Joined: Aug 2001
Access includes an upsizing tool to migrate to MS SQL. There are also plenty of tool s out there to move to MySQL as well.
vexcom posted this at 05:22 — 16th July 2004.
He has: 21 posts
Joined: Jul 2004
MySQL is free and is so much better than access that it makes me lightheaded.
Access + WWW = bad
MySQL + WWW = good
druagord posted this at 16:46 — 23rd July 2004.
He has: 335 posts
Joined: May 2003
access is a little one to 5 user database it's engine is slow and nothing as been done to make better for the web. comparing access to any sql server is like comparing paint and photoshop.
IF , ELSE , WHILE isn't that what life is all about
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.