[Babase] Row limits with Import button and Upload program
kfenn
kfenn at princeton.edu
Thu May 8 10:04:39 EDT 2008
Karl,
Sorry to be so delayed in responding (I was on vaction). Please see my
comments below.
Karl O. Pinc wrote:
>
> On 04/10/2008 10:45:41 AM, kfenn wrote:
>> 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:
>>
> The problem is in the webserver configuration. There's a number
> of default limits that I've just upped.
>
> You should now be able to upload a 100MB file, unless it takes
> more than 200MB when encoded to transfer over the network or
> unless the uploading php program takes more than 128MB of total
> memory.
>
> Please try it and see if it works.
I successfully uploaded about 34,000 records from the weather data so
the 20,000 record barrier has definitely been broken. Maybe Catherine
can also test it out by re-importing some of her GPS tables, which I
believe are much larger.
Tabby
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
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