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

Hmm, Perhaps I am asking a silly question but. Was the Informix engine on a server accessed via the network and the ms-access engine on your local machine? or put another way what is the network connection like between the client and the server? Cheers David -----Original Message----- From: reuben [mailto:news@boo.NOSPAM.co.nz] Sent: Friday, August 25, 2000 9:19 AM To: informix-list@iiug.org Subject: Re: MS Access performed faster than Informix in 800000 row tests Not to sure off hand, but we have 2x 1 gig filechunks. and its not raw sapce, its on NT. <Z@forget.about.it> wrote in message news:39aa0028.30476729@news... > How fragmented is the Informix table, disk space wise? > > The same question for Access table. ************************************************************************This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.

Data transfer is not an issue, querys have been performed at the server. This is a summary of the agregate query that was performed on both databases. SELECT fk1, fk2, COUNT(*), SUM(qty) FROM bigtable GROUP BY 1,2 Scans approx 839000 rows Returns approx 300 rows fk2 is an integer, fk3 is an CHAR(5), qty is a FLOAT Informix Time: 2:30minutes MS Access Time: 40 seconds No indexes on MS Access. Any ideas? David McPaul <dmcpaul@lumley.com.au> wrote in message news:8o4du1$n7h$1@news.xmission.com... > > Hmm, > > Perhaps I am asking a silly question but. > > Was the Informix engine on a server accessed via the network and the > ms-access engine on your local machine? > or put another way what is the network connection like between the > client and the server? > > Cheers > David > > -----Original Message----- > From: reuben [mailto:news@boo.NOSPAM.co.nz] > Sent: Friday, August 25, 2000 9:19 AM > To: informix-list@iiug.org > Subject: Re: MS Access performed faster than Informix in 800000 row > tests > > > Not to sure off hand, but we have 2x 1 gig filechunks. and its not raw > sapce, its on NT. > > <Z@forget.about.it> wrote in message news:39aa0028.30476729@news... > > How fragmented is the Informix table, disk space wise? > > > > The same question for Access table. > > ************************************************************************This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.