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 ?