On Sep 12, 2009, at 12:00 PM, John wrote:
> Which brings a question to mind about the size limits of lists.
> Let's say the
> pgpks was over 100,000. Would it still work? Where would it stop
> working?
There is no arbitrary limit. It's memory limited.
> To get around the size issue would you use a loop using a fetchone
> routine?
No, since the data is already in the cursor.
> I was working with only a gig or two and did not run into issues
> transfering
> data. But I wondered what would cause the system to break.
> I'm just wondering what happens when dealing with large data sources.
A record-by-record approach would not work for another reason: you're
looking for records in the ms table that don't exist in the pg table.
You need to have all the pg records to make that determination.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/f26b7e03-ff60-4c93-ba2d-ad993f4a9...@leafe.com
