DBC mixed with Free tables performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Dan" <dan@xxxxxxxxxx>
Date: Fri, 1 Jun 2007 13:57:50 -0400

I am using VFP9.

I am in the process of creating a database container for my free tables. I
have quite a few tables and would like to implement this incrementally.

My question is, are there any performance problems with mixing tables in a
dbc with free tables?

I have a query that uses 4 tables to get some data. When running it against
my free tables it runs in under a second. When I run the query against the
same 4 tables only with two of them now added to the database container the
query takes over 30 seconds. I am not sure why this is happening.
SYS(3054) reports the same optimization for both queries.

Please help...

.

Follow-Ups:
- Re: DBC mixed with Free tables performance
  - From: Dan

Prev by Date: Re: Send mail programming help needed
Next by Date: Re: Listbox scroll bars wierdness
Previous by thread: Re: Send mail programming help needed
Next by thread: Re: DBC mixed with Free tables performance
Index(es):
- Date
- Thread

Relevant Pages

Re: How to access query in VBA
... In the database container exists query called MyQuery: ... When you open this query from the database container, you'll get a prompt to ... Dim rstCustomers As Recordset ...
(microsoft.public.access.queries)
Re: DBC mixed with Free tables performance
... Can nobody help me? ... I am in the process of creating a database container for my free tables. ... I have a query that uses 4 tables to get some data. ... SYSreports the same optimization for both queries. ...
(microsoft.public.fox.programmer.exchange)
Re: DBC mixed with Free tables performance
... I am currently working with test data so ... I am in the process of creating a database container for my free tables. ... are there any performance problems with mixing tables in ... I have a query that uses 4 tables to get some data. ...
(microsoft.public.fox.programmer.exchange)
Re: DBC mixed with Free tables performance
... A table in a DBC vs a free table should have no impact on performance. ... Are they on a network share or local? ... I am in the process of creating a database container for my free tables. ... I have a query that uses 4 tables to get some data. ...
(microsoft.public.fox.programmer.exchange)
Re: specifying format in SQL
... I'm not quite up to VFP9. ... although the result I got in the query was N 14,2 instead of N 10,2. ... Jeff ... >> can accomodate the possible 6 digit number without losing a digit. ...
(microsoft.public.fox.programmer.exchange)