Support for SQL Server...

Post Reply
donnie
Posts: 1
Joined: Sat Jun 12, 2004 12:52 pm

Support for SQL Server...

Post by donnie »

Alex,

I was curious if Newspro could be written with SQL Server as the backend database?

-Donnie
alex
Posts: 4514
Joined: Thu Feb 27, 2003 5:57 pm

Post by alex »

no.

there are much better arrangements.

when the newspro database is in memory it is very fast, so using sql won't help since i'm not sure sql has memory management. if they don't use memory mapped files or some form of locking records in memory it will be much slower. if currently some operations are slow on large lists and something better is possible it is not a database problem in the sense of set of tables.

my opinion is, the best possible database is a custom one, since the disk data structures are simple (it would be the sql part), the critical issue is how data are arranged in memory dynamically while the program is running and it is not sql domain.

so what is left for sql is very limited function like saving/loading newsgroups and to write such a code takes only few days, so why to use a monster. as to the newspro database - both static and dynamic part - a better arrangement is possible but without sql.
Post Reply