Can You Solve My Problem

Can You Solve My Problem

Post by Bpk. Adi W » Sat, 02 Apr 2005 02:11:52


I have 2 tables/data. first table from SQL Server. The other table from
Paradox.

SELECT * FROM ":ASQL:dbo.TABLE_SQL"
WHERE NOID IN (SELECT NOID FROM ":APRDX:TABLE_PRDX.db")

This statement, I write in TQUERY and execute it. It can work, but very-very
slowly.

Do you have idea, to be quicker of its process without altering its target
intention? May be to use ADO or something that better?
 
 
 

Can You Solve My Problem

Post by Wayne Nidd » Sat, 02 Apr 2005 06:52:52


Because you are selecting from tables in two completely different databases
(database types), the BDE itself has to perform two separate queries, then
calculate the result set itself. The BDE makes it *possible* to do this, but
not quickly. I do not believe ADO can do this at all, but even if it can, it
would have to do the same work.

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.yqcomputer.com/
In a tornado, even turkeys can fly. - unknown

 
 
 

Can You Solve My Problem

Post by Bpk. Adi W » Sat, 02 Apr 2005 10:14:06

Hi, Wayne Niddery. If in my problems, Table Paradox only as table
Temporary, So Do you have idea, to be quicker of its process without
altering its target intention? May be to use ADO or something that better?
 
 
 

Can You Solve My Problem

Post by Wayne Nidd » Sat, 02 Apr 2005 13:35:00


If you are creating temporary records in this Paradox table just to do such
queries, then do not use Paradox, create the temporary tables in SQL Server.
Then SQL Server itself can execute the entire query for you directly and it
will be *fast*. You can still use the BDE, but will no longer have to depend
on the BDE *performing* the query for you, but only returning the results
from SQL Server.

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.yqcomputer.com/
"Nature abhors the vacuum tube." - J.R. Pierce, Bell Labs engineer who
coined the term 'transistor'