[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]

Re: [school-discuss] Web-based School Administration...

On Fri, 22 Aug 2003 01:23, David Frankson wrote:
> As far as databases go, we use SQL Server, and I am very happy with
> it.  Its impressive to see 100k+ student districts and states running
> hundreds of transactions per second.  At times we have managed to
> push SQL Server to its limits, and we have not been able to get that
> kind of output out of any of the open source databases.

I'm surprised that you haven't been able to get that out of PostgreSQL 
or ibFirebird. MySQL, I could understand; it's fine for lots of simple 
reads but anything complex or involving many writes and it all goes 
wahoonie-shaped. Were you running through ODBC or direct? That makes 
about a 50% performance difference in some circumstances.

Cheers; Leon