SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: Limitations of Access
-
Sep 19, 2003, 04:30 #1
- Join Date
- Apr 2003
- Location
- United Kingdom
- Posts
- 94
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Limitations of Access
I am using Access 2000 as a backend database for a web application I am running, can anyone tell me what are the limitations of Access and also, What is the maximium size that an Access database can get to etc
I am starting to experience a slowness of the site and was thinking I need to update to SQL server and I think Access 2000 is to blame
-
Sep 19, 2003, 04:36 #2
-
Sep 19, 2003, 04:47 #3
- Join Date
- Aug 2002
- Location
- Burpengary, Australia
- Posts
- 4,495
- Mentioned
- 0 Post(s)
- Tagged
- 1 Thread(s)
http://www.sitepointforums.com/showp...8&postcount=11
Very good in terms of the limitations of Access, but doesn't help much in comparing with other RDMS.
-
Sep 19, 2003, 06:21 #4
- Join Date
- Nov 1999
- Location
- Mechanicsburg, PA
- Posts
- 7,294
- Mentioned
- 123 Post(s)
- Tagged
- 1 Thread(s)
Those links are fine. Some other things to consider: there are a number of factors that can influence the power of Access 2000:
- How many people are accessing your website at any one time? The specs always say 20, but that is people accessing your database at the exact time (ie connect to your page at the exact same moment which causes your database to be accessed for the data), so that number can be realistically as high as 100 depending on how much data is needed to build your pages (lower if your site is VERY data driven)
- Which driver are you using to connect to the database? OLEDB or ODBC?
- When was the last time you compacted the database?
- How well do you have your asp coded? Have you optimized the code to it's fullest extent? Are you opening connections/recordsets at the last second and closing them when not needed? Are connections pooled?
- Do you have all the appropriate indexes in place?
I'm not saying don't go to SQL Server, but the expense is not insignificant and it's not as easy as just copying the data over. If you can put if off for a little while, look heavily at those last two before making the jump up.
Just my .02Dave Maxwell - Manage Your Site Team Leader
My favorite YouTube Video! | Star Wars, Dr Suess Style
Learn how to be ready for The Forums' Move to Discourse
Bookmarks