Re: query the data in Informix very slow

Posted in 2000

Obnoxio The Clown — Fri, 04 Aug 2000 13:37:59 BST — source: Informix-list mailing list archive (1991-1998)

UPDATE STATISTICS? From: Karl-Heinz Braun <khbraun@vegla.de> > >Does the same query behave differently without ODBC ? >KHB > >Patrick wrote: > > > I use Informix 3.31 ODBC driver. When I query the data from > > the database, it nearly spends me more than 5 minutes. The > > returned number of records should be zero. And the table > > contains about 20,000 records. I use VB and ADODC. > > > > Any help and suggestions will be appreciated. > > > > * Sent from AltaVista http://www.altavista.com Where you can also find >related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is >Beautiful > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com