run oracle sql from delphi

[digitalgerrit]

Hello,

I have some ORACLE queries I want to run. When I do this from ORACLE SQL Developer, they run OK, but when I run them from Delphi it takes far too long. This is because I'm talking about millions of records, so performance is a real issue here. However, the whole process should be managed from a Delphi interface. What I want to do now is to call SQL Developer from Delphi, load the SQL scripts automatically and run them. Does anyone know how to do this?

Any help will be greatly appreciated, thanks.

 

[lespaul]

how are you running the queries in Delphi?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[digitalgerrit]

I define the Queries as BDE objects, and run them in code like:
qryName.close
qryName.open
qryName.requestlive := true
qryName.Insert
'filling code for each field to be filled
qryName.Post

This works allright, but for every record some logic is applied and overall performance is slow. However, run directly from SQL Developer it seems to run much faster.

 

[whosrdaddy]

please oh please, DITCH the BDE (it's slow and a pain in the *ss)

use a native oracle component like the ones from crlab:

http://www.crlab.com/odac/

my 2 cents...

/daddy



-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[digitalgerrit]

Thanks for the input!
I'll try it and let you know the results