Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)
Peter Brown wrote:
>
> Does anyone out there have any idea for a single data table (of row
> size 608 bytes) of 3.8gb with one numeric index of long integer
C-ISAM files are limited to 2 GB. That gives you a problem.
IDS can fragment the table across multiple dbspaces; with C-ISAM,
you'd need two separate C-ISAm files and a fancy policy for deciding
where to put each row that's inserted.
> Whether C-Isam would do the index lookup and return appropriate row
> quicker than IDS. Do you think it would significantly speed up the
> lookup if I put the index table in memory (25mb).
Maybe; could you do that without IDS or C-ISAM co-operating?
> I'm just in design phase and ask this question because I haven't
> bought C-Isam or hardware yet. Operating system is Linux
My answer is not platform dependent.
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN
#include <disclaimer.h>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.