How much data do you have (number of records)? Can you provide a small sample of data from which one may re-produce the error?
On Fri, Dec 19, 2008 at 3:26 PM, Matthew Brand <[email protected]>wrote: > Dear All, > > I am trying out JDB by creating a database of football (Soccer) scores. > > I create the following tables and everything runs smoothly: > > load 'data/jdb' > NB. You must create the empty directory '~user/projects/football/data/jdb' > > ffd =: Open_jdb_ jpath , '~user/projects/football/data/jdb' NB. football > folder > fdb =: Create__ffd 'football' NB. football database > matchdatetable =: Create__fdb 'matchdate' NB. stores the match dates > teamnametable =: Create__fdb 'teamname' NB. stores the team names > matchtable =: Create__fdb 'match' NB. stores the matches that have occurred > ftagtable =: Create__fdb 'ftag' NB. stores the Full Time Away Goals > > InsertCols__fdb 'matchdate';'matchdate varchar;' > InsertCols__fdb 'teamname' ;'teamname varchar;' > InsertCols__fdb 'match'; 0 : 0 > hometeam teamname > awayteam teamname > matchdate matchdate; > ) > > This all occurs without issues. Then when I try to insert the columns for > the results table (say the full time away goals): > InsertCols__fdb 'ftag'; 0 : 0 > match match; > value int > ) > > , no error is generated but the system uses all of the processor for at > least 10 minutes. When I use jbreak to stop it from running I get: > > |attention interrupt: dbsortdir > | dbsortdir'' > > Any thoughts? > > Thanks, > Matthew. > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
