Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!ucbvax!bloom-beacon!athena.mit.edu!joe
From: joe@athena.mit.edu (Joseph C Wang)
Newsgroups: comp.databases
Subject: Help with RTIngres 5.1
Keywords: quel, ingres, help
Message-ID: <1989Dec13.231419.16400@athena.mit.edu>
Date: 13 Dec 89 23:14:19 GMT
References: <590@aut.UUCP>
Sender: root@athena.mit.edu (Wizard A. Root)
Reply-To: joe@athena.mit.edu (Joseph C Wang)
Organization: Massachusetts Institute of Technology
Lines: 14

I have a table of about 40,000 rows.  Whenever I try to add about
10,000 more rows via the copy command the database freezes up for
hours at a time if the table is organize as a chash or cbtree table.
I get around this be modifying the table to cheap, adding the rows,
and modifying it back to chash or cbtree.  Is there a better (i.e.
faster) way?

Also are there books on optimizing Ingres, the technical notes seem
a bit sketchy.

-------------------------------------------------------------------------------
Joseph Wang (joe@athena.mit.edu)           Wake Up! Wake Up!
450 Memorial Drive C-111                   All who wish not to be slaves.
Cambridge, MA 02139