Re: C-ISAM Library

In article <D3zyGE.EL0@crash.cts.com>, Lynn Wood says... > >I have a question in requards to Large Files. I have several 300MG files >that have 3 to 5 indexes. These indexes are needed on a regular basis. > >The problem I have having is that when I update a record, Even it the indexes >don't change, the library reads and checks all index anyway. Most B and >B+ trees I have used in the past had seperate calls for writing records and >adding, changing, or deleting keys. I add about a million records in a week. > >If I drop the indexes the program that adds the records run almost 6 >times faster. > >Now for my question. Would Informix Online, Sybase, or Oracle suffer from >the same problem, and if so is there anyway around it. > >Greg > First question, are you performing reads to the same table(s) when you're updating or inserting records? How are you performing the update/insert? Which function call(s) are you using? Are you updating via the rowid, especially when you don't update the key value? It's hard for me to tell you that the OnLine engine or Oracle database would perform any differently. Guess this is a start. -- Albert E. Whale aewhale@emi.lm.com ---------------------------------------------------- Sr. Systems/Database Consultant Executive's Monitor, Inc. 1789 S. Braddock Ave, Ste 220 Pittsburgh, PA 15218-1868 (412)243-4600 Fax: (412)243-4830