Mailing List Archive


Back to the month index Back to the list index
Shun Gao - 3669702 (sgao@nunic.nu.edu)
Sat, 28 Sep 1996 16:15:49 -0700 (PDT) 

Date: Sat, 28 Sep 1996 16:15:49 -0700 (PDT)
From: Shun Gao - 3669702 <sgao@nunic.nu.edu>
Subject: [mSQL] add column to a table
Message-Id: <Pine.GSO.3.92.960928160246.29471A-100000@nunic.nu.edu>

My attempt to add a column to an existing table yield severe
bugs/errors.

* Following the instructions in the FAQ, I dumped the schema and the
content of the table, add a field to the schema, create the new table,
modify the dumped data, and use the msql monitor to insert the data into
the new table. All this works fine for tables with small number of
records.
However, this does NOT work for tables with number of records more than
20 - the msql monitor simply gets "chocked" and won't insert the records.
What is the reason for this dismal performance of the monitor?
Is there anywayt to force the poor monitor to handle more than 20 records
at a time?

* I wrote a PHP code that automates all the above process. again, the
program would succeed with small tables, but when it runs on large
tables I get "You have exceeded the maximum allowed data space of
8388608 bytes on line 471..." and the program aborts prematurely. Why?
The total content of the table is 300KB, so it's far below the error's
declared 8MB. Also, both my development PC and the sever have plenty of
memory available. Did anyone confronted a simillar problem? Any feasible
solutions?

Does anyone have another suggestions how to add a column to a large
table?

Thanks in advance,

Shun Gao

Jacob Research Institute

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!