[Modus] performance

[Michael B. Smith]

The local access databases don't have the indices --- and the SQL server databases do --- so I'm not certain that they are faster. I was hoping someone from support would chime in here.... From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Shaffer Sent: Tuesday, February 03, 2004 4:19 PM To: [EMAIL PROTECTED] Subject: [Modus] performance Just my 2 cents. The real question is what size DB will be needed. Ounce you hit the 2GB size Access is done. We are running three Modus servers and SQL2000 and there does not seem to be a throughput issue. I do not have hard data to back it up but if many years of experience, a local Access DB would be faster than a ODBC connection to another server. If SQL is on the same server as Modus I would go with SQL. Keep in mind the SQL desktop edition has a connections cap, 5 connections I believe. So if you wanted to expand from this to say, have an small counter script on your website to show customer how many spasm you caught for them in the last day, week, month…  you will start to run out of connections.   Hope this is helpful. Charles   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Michael B. Smith Sent: Tuesday, February 03, 2004 3:34 PM To: [EMAIL PROTECTED] Subject: [Modus] performance   Is their written/web documentation that indicates better performance would be experienced via ModusGate and ModusMail using SQL?? (I know, but another ISP is giving me crap and I need to point them to hard data.)