Re: Fast Queries

In article <2nfjch$n0i@emory.mathcs.emory.edu> you write: } Somehow, somebody managed to code a } bunch of C programs that access the Informix 3.3 files. I'm not familiar with } the old 3.3 package, but the Intel computer does not have C-ISAM or ESQL/C on } it. All it has is Informix 3.3. Wasn't there a way you could call C functions } from Perform? And could you then drop all your unused .frm files and access } the .dat/.idx files using your C programs?? Just curious. } In version 3.3 of Informix there was a set of C functions called ALL-II. These functions allowed you to access the database from C but were later fazed out when C-ISAM hit the shelves. Last I heard, ALL-II is available once again. Embedding C in you forms with ESQL/C and the ALL-II library is like apples and oranges... no relation whatsoever. } Gee, wouldn't it be faster to search just 4 tables, even though they will } be comparatively extremely large, than to search through 40 tables in 10 } directories??? } I'd think so. } Also I will be using one VIEW since there is one user of the database that } will always query for the same subset of master records. Will a VIEW be } slower than a SELECT with the appropriate WHERE condition? } There would be no speed difference because a view IS a select with the appropriate where condition. DAS -- Dave Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.17 UUCP: ..!uunet!das13!dave INTERNET: dave@das13.snide.com