Usenet Explorer

Forums
It is currently Fri Jul 20, 2018 8:04 pm

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Support for SQL Server...
PostPosted: Sat Jun 12, 2004 12:54 pm 

Joined: Sat Jun 12, 2004 12:52 pm
Posts: 1
Alex,

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

-Donnie


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jun 12, 2004 4:11 pm 

Joined: Thu Feb 27, 2003 5:57 pm
Posts: 4370
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group