Alright here is the first observation If I use QiQ to control the process I can fix the problem
First I created a query that joins Customers and Oreders Saved it as Customer_Orders Then created a second query that uses Customer_Oders and joins OrderDetails to this. Selected all fields from both objects and GREAT - the query runs in a just a few seconds On 8/16/07, Andrew Jensen <[EMAIL PROTECTED]> wrote: > > Oh yes - XP SP 2 all updates as of yesterdays release from MS > OOo 2.3m_1 > > On 8/16/07, Andrew Jensen <[EMAIL PROTECTED] > wrote: > > > > You don't need an 80 meg database. > > > > You can see an example of this with any of the example databases > > supplied by microsoft. > > > > The problem seems to be when you link in the third or greater table. > > > > For instance - using the file QrySampl.mdb ( available from the MS web > > site - or ask and I;ll send it along it is only ~670K ) I have done the > > folloiwng: > > > > Connected using MS Access > > Connected using ADO exclusive mode > > Connected using ODBC > > > > I am using the following three tables only > > Customers ( 91 records ) > > Orders ( 830 records ) > > OrderDetails ( 2155 records ) > > > > Now if I create a query that joins Customers to Orders - no problem > > But - add OrderDetails to the query and BAM takes about 2 minutes to run > > and the CPU is at 100% for the whole time. > > ADO exclusive is slightly faster - but not enough to make it usable > > ODBC is just the same > > > > anyway - I am not done just yet with this..so I will put up more as I > > have it. > > > > > > > > On 8/16/07, Regina Henschel <[EMAIL PROTECTED]> wrote: > > > > > > Hi Jens, > > > > > > Jens Ansorg schrieb: > > > > 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. > > > > > > Do you have tried an ADO connection too? > > > > > > > > > > > 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 :( > > > > > > Can you please post an example SQL statement? > > > > > > > > > > > > > > > > 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? > > > > > > I would like to try it on my PC, but how to get a 80MB access database > > > file? > > > > > > kind regards > > > Regina > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > >
