Re: SQL Select: Very Fast in VFP8, Very Slow in VFP9

Thanks to all for your help. Here is some additional information:

Code page for the two tables in the SQL Select statement is set to
1252.
Default code page is 1252.
Default collation sequence is set to "MACHINE".
SQL Select does not use STR().
No records marked for deletion.
Free tables.
No indexes.

=============
Here are the results of SYS(3054,11) for the same SQL select statement:
------
VFP9 (Time for completion: 6 minutes)
-----
Rushmore optimization level for table TABLE1: none
Rushmore optimization level for table TABLE2: none
Joining table TABLE1 and table TABLE2 (Cartesian product)

===========
Next, VFP8 (Time for completion: Less than 1 second -- too fast to
time)
-----
Rushmore optimization level for table TABLE1: none
Rushmore optimization level for table TABLE2: none
Joining table TABLE1 and table TABLE2 using temp index

====
Any suggestions?
Thanks again!
David

.

Relevant Pages

  • Re: Can this be done using a Data adapter??
    ... values to table3. ... view and manually run the insert or update SQL commands. ... have the 1st column read only and put the table1 values there). ... have done up to now is i bring the data of table1 and table2 from the ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Table as Criteria
    ... > Build your SQL statement in VBA using the table names picked by the user from ... > Select Table1.* from Table1 etc. ... > Select Table2.* from Table2 etc. ... >> I would like to do a dynamic query, but don't know how, so if anybody could ...
    (microsoft.public.access.queries)
  • Re: sql problem
    ... while Table2 could have 3 rows per key. ... insert into table1 ... The requirement is I have to come up with a report comparing the two ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... while Table2 could have 3 rows per key. ... insert into table1 ... on the report those names that are different across the two tables. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: how to create a function w/in a query?
    ... Table1, with fields a,b,c ... Table2, with fields h,i,,j ... I want a query that does something like this: ... SQL queries... ...
    (microsoft.public.access.queries)
Loading