Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am considering using SQL CE for multithreaded server where there is at approx. 80 clients often (secs) working with data in DB. I know MySQL (EDIT: unoffical servers) has no problems (World of Warcraft speaks for itself), but what about that? Thanks!

share|improve this question
    
I thought WoW runs on Oracle –  Remus Rusanu Dec 22 '09 at 17:55
    
Sorry, I meant unoffical servers –  Tomas Dec 22 '09 at 17:56
add comment

1 Answer

up vote 0 down vote accepted

For a server, I would recommend SQL Server Express Edition - I have used it on a server with higher loads than you mention with no problem. Is there a reason you are using SQL CE? To my knowledge, SQL CE is recommended primarily for embedded apps and on handheld devices where you cannot use a full server-edition product.

share|improve this answer
    
OK, also many threads asking at the same time is no problem? I am afraid whether it would not cause lags. –  Tomas Dec 22 '09 at 18:23
    
Not with a database. They're designed to handle things like that - that's probably their primary advantage over using a flat file. –  Ed Leighton-Dick Dec 22 '09 at 22:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.