SQL vs. VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if a trigger created via sql in Oracle would perform faster
than the equivalent vba function in excel that is uploading to Oracle?

Either way I am running a program to upload data into Oracle using VBA. I
was thinking of making some of the Excel VBA tasks the database's tasks
through a trigger, but in order to do that I have to do the "work aorund" for
Oracle so I can work on the same table. I experimented with a small dataset
and when using triggers, the program time seemed to triple if not more. Any
thoughts? Thank you.

Brent
 
To be honest, the only thought that crosses my mind is:

Try it and find out.

MH
 
Depends on what the trigger does, and whether it's implementing a "business
rule" which would apply to all data going into the table, or just the data
being loaded from your application.


Tim
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which Oracle home does VBA use? 1
Addnew 1
How can I export txt(UTF-8 characterset) from Excel? 4
Using VBA to trigger a certain slide 0
Excel & MS Query caused compile errors 14
VBA Excel: Trigger a refresh upon data change in sql connection 2
Oracle Sequence Jumps by 3 from Excel 1
Automaton error/Unspecified error 1

Back
Top