Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!decwrl!shelby!agate!sunspot.berkeley.edu!ericco
From: ericco@ssl.berkeley.edu (Eric C. Olson)
Newsgroups: comp.databases
Subject: YAQA Sybase
Message-ID: <ERICCO.91Feb21171949@sdaf1.ssl.berkeley.edu>
Date: 21 Feb 91 23:19:49 GMT
Sender: usenet@agate.berkeley.edu (USENET Administrator)
Distribution: comp
Organization: CEA @ UC Berkeley, Berkeley, CA, USA.
Lines: 20

Yet Another Simple Question about Sybase.  I want to fill in a table
of information that already exists on disk.  I simply need to get the
data into Sybase.  The only technique I know is:

	insert into mytable values (1,2,3)

repeat a couple of hundred times.  This seems to be unacceptable to
Sybase.  It complains about not having enough memory to forfill the
request -- it seems to require more than 64 pages.  So I added some
code to send off shorter groups of insert commands.  This seems to add
an extraordinary amount of time to the loading.

Is there some better way of loading a table of information into
Sybase?

Thanks in advance,
Eric
--
Eric
ericco@ssl.berkeley.edu


Brought to you by Super Global Mega Corp .com