dbTalk Databases Forums  

Need a recommendation on DBS

comp.database comp.database


Discuss Need a recommendation on DBS in the comp.database forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
TSH
 
Posts: n/a

Default Need a recommendation on DBS - 11-22-2004 , 02:58 PM






I need a database system which is suitable for time-series data.
That is nearly all tables in the DB are flat tables with very little
relationships.
I used to use Ms-Jet but the 2Gb size limitation was getting to be problem.
Swithcing to ms-SQL was expensive and hard but it worked.
The problem is that ms-SQL is VERY SLOW to read and write large blocks of
data.

If I just read/write the data from/to text files myself it goes more than 5
times faster.
I'm guessing that all the overhead is because of the relational work that
ms-SQL does.

Is there a DB system which is designed for a collection of unrelated tables
which does not have a size limit?

From what I have seen, I suppose anything is going to be faster than ms-SQL.

Ernesto



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.