[OT] Fast DB access

2001-05-21 Thread Differentiated Software Solutions Pvt. Ltd.,
Hi, This is a follow up of mails sent to this mailing list last month. We were benchmarking several db access methods and comparing them with postgres. Lots of people advised us to try pg 7.1 instead of pg 6.5.3 This turns out to be good advice as regards performance. (We would like to

Re: [OT] Fast DB access

2001-04-20 Thread Differentiated Software Solutions Pvt. Ltd.,
Hi, Cees has found a bug in our benchmark. We were using rtrim in our select statement while doing the benchmark and this was forcing postgres to perform a table scan. We've corrected the code for this bug. We are reposting results without rtrim (creating the tables with varchar). In fact with