Re: Speed difference C-ISAM and IDS on Linux

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>