Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sajj
Starting Member
3 Posts |
 Posted - 2005-01-10 : 04:25:31
|
| In my forum, I am using MS ACCESS as the database. Concurrent users will be aroung 1000 to 1500 at any point of time. The forum is dead slow now. Is it because of ACCESS database? What is the maximum number of the concurrent users that ACCESS can support??Please suggest any idea to improve the performance of my forum...Thanks in advance...Sajj |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-01-10 : 05:39:51
|
| A number that has been seen here before in relation to this topic is "5"!!!Search here for "Concurrent", "MS Access" + "Performance" |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-10 : 08:59:31
|
You can get more than five, however, what other options do you have? Can you upgrade to SQL Server ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
|
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-01-10 : 09:50:37
|
| I wouldn't allow more than 5 or so connections to an Access db; techinically it can support quite a few, but realistically 5 is probably the max. Be sure you are familiar with how Access works, versus a true server like SQL Server. Access is not a client/server system, clients directly access the filesystem and manipulate the MDB file directly, so you are limited to realistic physical limitations of 5 processes opening and editing a file at the same time! Whereas SQL Server has 1 connection to the phsycal database file which is managed by a single, central server.If you are stuck with Access, and you are a good programemr, you could probably write a simple layer between your App and Access which acts as the server -- I've thought of doing this in the past. The app simply has a single connection to the MDB file, and accepts and queue's ALL requests, and processes them 1 at a time, and returning data to the clients. If all of the queries are quick requests, this might actually work pretty well (much better than many concurrent connections, anyway).- Jeff |
|
|
|
sajj
Starting Member
3 Posts |
Posted - 2005-01-10 : 22:55:05
|
| Thanks for the responses friends.....I can not migrage to SQL as it is costly. But I can go to any freeware. I am planning to move to MYSQL. Please advise me whether this will help me, if so how can I convert all the data that I have in mdb file to MYSQL? I am using SNITZ forum only.Jsmith, Please tell me how to write the layer between application and access (Links will be enough, I will learn and do)Regards,Sajj |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-01-11 : 08:54:23
|
| Two things:1) This is nothing I can "show you how to do" -- there's no wizard that will write a server application for you! That's why I added this requirement for that particular idea:>>and you are a good programemr [sic]2) this method would not be feasbile to use with existing pre-written software, since you'd basically need to rewrite the entire thing. It's more if you have a web application that you wrote yourself.- Jeff |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-11 : 20:59:10
|
| Since you're using the Snitz forum, you should go to the Snitz home and post your question there (if you haven't already) Someone may have already created a utility to move the forum data from MS Access to MySQL, which is probably all you really need. Failing that, you can always about your Access tables to text files and import those files into MySQL once you get it configured.For future reference, MSDE and the upcoming SQL Express are free versions of MS SQL Server. They do have some limitations but they might work for you. You can find out more about them here:http://www.microsoft.com/sql/msde/ |
|
|
|
sajj
Starting Member
3 Posts |
Posted - 2005-01-12 : 23:04:46
|
| Thanks a lot guys. I decided to migrage to MYSQL from ACCESS. Hope that will give speed to my forum and make it lively.Sajj |
|
|
|
|
|
|
|
|
Will MS ACCESS Support this?