April 28, 2009 at 11:33 am
We run CAREWare freeware distributed by HRSA under the SQL 2000 Desktop Engine. NOT including additional bells and whistles, is there any computational (speed/ram, etc) advantage to using the desktop engine versus running under a data instance connected to the full-blown SQL-2000 Server ? I am looking at running the provided software only. Any extra query capability, file management, backup, etc, is not to be considered...performance only.
Some here say we will have better response times using the full blown version, others say the desktop engine is better. I would assume that the actual processing of SQL is done by the same engine in both.
Any ideas/comments ?
April 28, 2009 at 12:09 pm
MSDE (Desktop engine) is a free restricted version of SQL 2000. It has a number of limitations built into it, one of which is a 5 connection limit. As soon as there are more connections that that, it will throttle performance down.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2009 at 2:04 pm
Thank you for the info !!! Thant's exactly what I needed...we have over 10 users and later on...more. We need to upgrade !
April 28, 2009 at 2:20 pm
I don't know if you can buy SQL 2000 any longer. It's been out of support for about a year now. Is upgrading to SQL 2008 an option?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply