MSDE scalability

Hi all,
Im currently evaluating a change from Sybase ASA to MSDE
(sql server desktop engine) on all client sites.
We cannot afford to buy a bigger edition of MSDE, so it
is paramount to our decision that MSDE can handle the
expected workload.
We have estimated our maximum load to be 10 requests per.
second, and have run basic tests to ensure MSDE can
handle it. The results were good.
It would be very interesting to hear from anybody with
actual project experience with MSDE. Anybody with an
oppinion on MSDE in a production enviroment should also
let their voices be heard.
Best Regards
AlexHi
Your post is implying that MSDE is a different database engine to standard
SQL Server, which it isn't, therefore the throughput should be as good. You
are limited by database size and number of connections though.
John
"Alex" <alex_pedersen@.accenture_com> wrote in message
news:101b01c38bd9$dd00ff20$a301280a@.phx.gbl...
> Hi all,
> Im currently evaluating a change from Sybase ASA to MSDE
> (sql server desktop engine) on all client sites.
> We cannot afford to buy a bigger edition of MSDE, so it
> is paramount to our decision that MSDE can handle the
> expected workload.
> We have estimated our maximum load to be 10 requests per.
> second, and have run basic tests to ensure MSDE can
> handle it. The results were good.
> It would be very interesting to hear from anybody with
> actual project experience with MSDE. Anybody with an
> oppinion on MSDE in a production enviroment should also
> let their voices be heard.
> Best Regards
> Alex

MSDE License when used with non-Microsoft database.

MSDE would make a great local cache in my app that uses dialup networking.
However, the App comminicates with sybase running on Linux.
Am I allows to use MSDE this way? Or should I use an open source database
for a local cache?
Thanks
From http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp it looks like
you're ok using MSDE.
joe.
"Karl" <Karl@.discussions.microsoft.com> wrote in message
news:F055A34F-DE27-4B55-A0B7-3E1B14F33097@.microsoft.com...
> MSDE would make a great local cache in my app that uses dialup networking.
> However, the App comminicates with sybase running on Linux.
> Am I allows to use MSDE this way? Or should I use an open source database
> for a local cache?
> Thanks
>