ericco@ssl.berkeley.edu (Eric C. Olson) (02/22/91)
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