[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