Help! Database Question
-
I have a question I am running a dual processor Xeon processor running IIS 5.0 and serving pages / info from an Access DB. I havnt run into any problems yet, but here is my question. Is there a maximum of concurrent users that can query the DB at one time? Are there any relevant restrictions that using an Access DB over say SQL server that I should be aware of. Can anyone provide me with information as to the benefits related with running a SQL Server over an access DB? It seems that when I am page loading from a MAC the server really chugs? any insight? I can use many PC's concurrently, but when I access the website with a MAC its quite a different story.. Any Help / Finger pointing to help would be appreciated. recurse.org - Recusion For the Rest Of Us.
-
I have a question I am running a dual processor Xeon processor running IIS 5.0 and serving pages / info from an Access DB. I havnt run into any problems yet, but here is my question. Is there a maximum of concurrent users that can query the DB at one time? Are there any relevant restrictions that using an Access DB over say SQL server that I should be aware of. Can anyone provide me with information as to the benefits related with running a SQL Server over an access DB? It seems that when I am page loading from a MAC the server really chugs? any insight? I can use many PC's concurrently, but when I access the website with a MAC its quite a different story.. Any Help / Finger pointing to help would be appreciated. recurse.org - Recusion For the Rest Of Us.
Hello, the codegurus around the world.;) Really? Did you use Access Database? Access Database isn't the thread-safe. That is, Access Database can't deal with con-corrent aceess on the web service. SQL server or Oracle actually use TCP/IP, meaning Socket level exchange. Or as long as you write the program with thread, Access database may be the thread safe.:confused: Have a nice day!
-Masaaki Onishi-