This beautiful fifth generation file format owns. Anybody with a half brain can open the header file and look at how the information is stored will see that this is the file format of the future. Can't get much more bang for the buck for this small footprint design.
So you don't agree the windows port has issues? The same database query that took 2 minutes now takes 10 seconds. That was the point I was trying to make. So don't assume we didn't cover the basics. A 10 second query is not un-heard of.
All I can recommend is perform as much benchmarking as possible before you pull the trigger. We picked Postgres over MS SQL Server (Strictly due to License cost) to upsize our current Access Database backend. Had we performed some basic benchmarking, we would have found that PostGres was terribly slower then MS SQL Server. Running the same basic query against our main table took PostGres over 2 minutes. MS SQL Server took 3 seconds. We found out the hard way that the Windows port of Postgres has some issues. We installed the Linux version and the performance is much better, now it only takes 10 seconds. Still slower then MS SQL server from our perspective. But that's why you need to install it and perform some benchmarking. Do not rely on others, including me, to tell you which is better. Not that Slashdot users are bias or anything...perish the thought.
Slashdot Mirror
This beautiful fifth generation file format owns. Anybody with a half brain can open the header file and look at how the information is stored will see that this is the file format of the future. Can't get much more bang for the buck for this small footprint design.
So you don't agree the windows port has issues? The same database query that took 2 minutes now takes 10 seconds. That was the point I was trying to make. So don't assume we didn't cover the basics. A 10 second query is not un-heard of.
All I can recommend is perform as much benchmarking as possible before you pull the trigger. We picked Postgres over MS SQL Server (Strictly due to License cost) to upsize our current Access Database backend. Had we performed some basic benchmarking, we would have found that PostGres was terribly slower then MS SQL Server. Running the same basic query against our main table took PostGres over 2 minutes. MS SQL Server took 3 seconds. We found out the hard way that the Windows port of Postgres has some issues. We installed the Linux version and the performance is much better, now it only takes 10 seconds. Still slower then MS SQL server from our perspective. But that's why you need to install it and perform some benchmarking. Do not rely on others, including me, to tell you which is better. Not that Slashdot users are bias or anything...perish the thought.
Are you refering to the concept of UDM? Univeral Data Model? Whatever you're working on, its data structure has been modeled before. Really. It has. In fact, it's probably been modeled times before. Some cool recommended reading: http://www.amazon.com/exec/obidos/tg/detail/-/0932 633293/qid=/sr=/ref=cm_lm_asin/002-7630614-0141659 ?v=glance
http://www.amazon.com/exec/obidos/tg/detail/-/0471 380237/qid=/sr=/ref=cm_lm_asin/002-7630614-0141659 ?v=glance