Please keep us informed about your success with this. I do not have any advice though. I tried to put 40M rows of stock data into JDB last year, but I never managed to do it. It would be nice to have some functions that can read through a text file given the definitions of the tables (relationships) which push the data into JDB automatically (and quickly!). I found it very fiddly to manipulated the data into the correct format for input and also very slow. It is likely that as more data goes into the tables it takes more and more time for it to do the constraint checks.
Most likely my failure was not the fault of JDB though, just the way that I tried to do it. You have a lot of rows, good luck. What data is it? 2009/9/25 Tirrell, Jordan (Consultant) <[email protected]> > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Matthew Brand > Sent: Thursday, September 24, 2009 4:48 PM > To: Programming forum > Subject: Re: [Jprogramming] JDB wrong data > > How many tables and how many rows in each table would you have? > > > > There are 8 tables in the current version. They have very different > sizes, the largest is over half a billion rows. > When complete, the whole database will be around 80-100GB. > > Jordan > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
