Just like to add that I have had similar issues with tables created directly in OOO Base (not connecting to Access). Queries seem to run very slowly when joining across multiple (e.g. 3) tables. My tables were small approx 8000, 2000, 100 rows respectively. The SQL and indexes are fine (I have 4 years experience with both Oracle and Teradata, and am not doing anything complex- so I don't think it is my table design or poor SQL that is causing things to run slowly). By slowly I mean it takes minutes to run a query when I was expecting it to run in seconds (as I said small tables). I assumed this was just OOO Base and decided to live with it .... but if there are any thoughts about why queries run slowly??? Darren
> To: [email protected]> From: [EMAIL PROTECTED]> Date: Thu, 16 Aug 2007 > 10:06:06 +0200> Subject: [dba-users] trouble with large MS-Access (mdb) > database> > hi,> > I try to use OOO Base 2.2.1 as a front end to a MS-Access > mdb file.> > The database file is about 80Mb in size.> > I sucessfully > created the link to the database using the "Microsoft > Access" Connector.> > > I can see all contained tables and also access all data within.> > Ok.> > > Trouble starts when I try to create Queries across more than one table. > No > matter whether I enter the SQL manually or use the wizard or the > design > view: when I try to view the query result - and even when I just > try to > save the query without viewing the result first - OOO Base starts > to use > 100% CPU and that's it ... forever until I kill it :(> > > > I tried to do > queries across several tables with a small sample access > database and this > works so I suspect that OOO has trouble dealing with > the huge amount of > data here?> > > > Anybody experience with hube access databases?> > > > > I > cannot provide the database file in question; it is available > (although for > a small fee). If you go to > http://www.navigraph.com/www/fmsdata.asp, the > last entrry to download > "Wilco/Feelthere 737/777, ERJ, Legacy, Citation X" > is a windows setup > that installs this mdb file on your harddrive (but you > have to be logged > into the site and for that you have to pay)> > > thank > you> Jens> > > ---------------------------------------------------------------------> To > unsubscribe, e-mail: [EMAIL PROTECTED]> For additional commands, e-mail: > [EMAIL PROTECTED]> _________________________________________________________________ Feel like a local wherever you go with BackOfMyHand.com http://www.backofmyhand.com
