[Babase] Row limits with Import button and Upload program
kfenn
kfenn at princeton.edu
Thu Apr 10 11:45:41 EDT 2008
Hi Karl,
Catherine M reported having trouble uploading more than ~20,000 rows of
data via the Import button in phpPgAgmin. The data were going into a
new table she created in her schema and was trying to populate. I've
been working with the weatherhawk data (about 35,000 rows of data) and
ran into the same problems (I can get about 20,000) in at one time, but
after that I get the error:
Import error: File could not be uploaded to the server
I have also tried using the UPLOAD program just for fun, but it seems to
max out at the same point. However, you can upload an entire table if
you do it in chunks of 20,000 rows.
Do you know anything about row/data limitations when importing or can
you suggest another approach for uploading lots of data? Maybe we
should just be creating the table with the data all in one step rather
than creating the table "shell" and populating it?
Thanks,
Tabby
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list