If you are referring to DBCopy plugin (that is, "Copy table" / "Paste
table"), there are
probably several configurations you would be interested in. The
"ResultSet fetch size"
controls how many records are loaded into memory at one time. If you
have large BLOBs,
then there is also setting to use a file buffer instead of memory.
These are both located
in the "DB Copy" tab in Global Preferences.
Rob
On Fri, Aug 28, 2009 at 3:48 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote:
> I have a Teradata table with over 900k rows that I need to import into
> Oracle. Would SQuirreL have any trouble getting this done? I can see
> the various pieces are available, but I'm not sure how
> memory-efficiently this gets done. Would I have to increase the maxmem
> for this? I'm running on Windows, so I can't get much more than about
> 1536m (I could probably squeeze more, but I usually stop there for
> safety).
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|