Buddy, Thank you. I am working with latest version of 9.5 64. The database is completely empty and it is all local. (The only thing I like to do is perform some statistics, because the data are being converted from a navision database) I will give it a try to load one table at a time.
Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Sent: zaterdag 22 september 2012 14:39 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: OBDC connection and huge tables Tony You didn't say what version of R:Base you are using and what is the size of the R:Base database without the connections. Make sure your scratch folder is local. Reload your R:Base database/ Attach only 1 table at a time and you set only one or two columns as indexed and do whatever you need to do then detach them. After each detach, disconnect from the R:Base database. Keep an eye on the size. If need be reload it again. If I remember right R:Base 9.1 and above allows you to attach tables as temp tables and I would still only attach one table at a time. Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Saturday, September 22, 2012 4:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - OBDC connection and huge tables Hi, I like to make use of an OBDC connection. In this case Interbase. In total the Interbase database is 69 GB and it contains a lot of data that needs to be converted to a new table structure. Basically it works wonderful, but there are some tables which are huge. Some tables do have over 190 columns and contain about a million rows. And there are tables with more than 6 million rows. At this point it goes wrong, if I try access these tables. What I can see is that needed memory of Rbase.exe grows to more than 1200 Mb and then it stops. My question is: Is there a workaround or an alternative connection available for these tables? Tony IJntema
