Re: DBC mixed with Free tables performance

My tables are on a network drive. I am currently working with test data so
I am the only one accessing it.


"Fred Taylor" <ftaylor@xxxxxxxx!REMOVE> wrote in message
news:e6$nQorpHHA.3952@xxxxxxxxxxxxxxxxxxxxxxx
A table in a DBC vs a free table should have no impact on performance.
Where are your tables located? Are they on a network share or local? Are
other people or applications currently accessing them?

--
Fred
Microsoft Visual FoxPro MVP


"Dan" <dan@xxxxxxxxxx> wrote in message
news:usBznSqpHHA.4196@xxxxxxxxxxxxxxxxxxxxxxx
Can nobody help me?

"Dan" <dan@xxxxxxxxxx> wrote in message
news:OORtfZHpHHA.4496@xxxxxxxxxxxxxxxxxxxxxxx
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...








.

Relevant Pages

  • Re: SQL query question #2
    ... and having test data makes it easier to test. ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis ... E.g. if I query the above data with required values of 'b' and 'd'. ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie: Help writing a sproc
    ... using the test data you posted earlie (changing the time on one row ... If you're sure you didn't make a mistake in copying the query, ... query will set the userid to NULL if the userid has at least one entry in ... So if userid 3 has an entry of 70 ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I empty a table?
    ... You could run a delete query: ... I have been known to open the tables, and select and delete all test data. ... run compact and repair. ... How do I empty the database of the test data when I've finished testing ...
    (microsoft.public.access.gettingstarted)
  • RE: Repost - help to merge 2 queries
    ... I will be interested if it works for more than the test data. ... 1st query with inner joins between table A and B ... I've quickly read the reply from John Spencer and what he has written lends ...
    (microsoft.public.access.queries)
  • Re: Combo values based on query
    ... Thanks (The query won't always return a single ... netry - it's just that I had a small amount of test data. ... Try using the OnCurrent event of the form to Requery the Combo box. ... consider using a caculated field, ...
    (microsoft.public.access.formscoding)