
09-19-2008, 12:13 PM
|
|
Gold Contributor 500+ Posts
Join Date: Sep 2008
Posts: 970
|
Web Store with Access 2002 Db
|
I have a web store that sells fashion accessories. I developed the web store on my own and link with Microsoft Accress 2002 db. The function of the web site is not that complicated.
1) No user login
2) Customer just search and read the data from the Access db (Customer search for products, pagination and bla bla bla.).
3) The only part to insert record to db is when the customer finished entered the products from shopping cart and finished entered shipping address.
I searched the net for performance issue info and a lot of developed commented that to use Microsoft SQL server 2000 instead Access.
So, my concern now is it necessary to migrate to SQL server or not from my current Access db...
I already thought that SQL server is only for BIG project.
So, do you guys or girls know that how to test with a lot of visitor on my own to my own web site? Is there any software outthere for testing the number of traffic to my web site? Thanks.
|
|
|
|
|
|
|