Re: MS Access performed faster than Informix in 800000 row tests

Are you running this test using the Web blade? What happens if you run via dbaccess? From: "reuben" <news@boo.NOSPAM.co.nz> > >Yeah, lock mode is wait, about 1 minute i think. >However, there were no concurrent users. >(BTW When there are, the 3rd or 4th query seems to get an error, but this >is >a slightly different issue. ) >A single user query has to be faster that what we're doing. > >BTW, what is the query you're doing on 1.5 million. Is this an agregate?, >or >a simple text search? >If the later, what kind of indexing are you using? > > >bob <bofh@mailbox.co.za> wrote in message >news:MPG.140efc762b43d1e098968f@news.dbn.lia.net... > > Huh? > > > > No ways hoss, we run a query like yours on 1.5 million in seconds, > > no ways access faster. Now, things to consider, how did you hit these > > tables? odbc or shm? > > > > The compaq box, operating system, quantity of users, lock modes? > > > > If a lock was held on a record, your query may have been set to > > wait with a timeout perhaps? > > > > I've seen informix clean up on sql server with no problems > > > > brett > > > > In article <8o263t$fta$1@news.wave.co.nz>, boo@boo.co.nz says... > > > I was recently asked to copy some data from an informix server to ms >access > > > so a customer could run some queries. > > > > > > Just for interest i ran my own queries first. > > > > > > There are 839000 rows in a table in both databases. > > > Informix is on a big compaq server with 2 cpus and lots of ram. > > > MS Access is on my pIII-600 with a single cpu and only 120meg ram. > > > Access had no indexes. Informix has plenty. Update statistics has >also >be > > > set. > > > > > > I ran a query using LIKE on memo fields and access came back within a >minute > > > with 13 thousand matches. > > > Informix performed not much faster on VARCHAR or LVARCHAR using >Excalibur > > > search index or even a standard LIKE. > > > > > > I also ran a simple agregate query, grouping on 2 columns, agregates >on >2 > > > columns, to return approx 300 results from the 800k odd. Access time >approx > > > 40 seconds, informix over 2 minutes. > > > > > > And informix had always been my favourite. > > > > > > Funny eh! > > > > > > Anyone want to tell me why I shouldn't give Informix the boot? > > > > > > > > > Cheers > > > Reuben > > > > > > For a better WEB DRIVER than Informix Web Blade, www.boo.co.nz/disco > > > For lots of funny jokes goto www.boo.co.nz/jokes > > > > > > > > > > > > > > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com