Re: Oracle 7 and Delphi 2 problem

Rick Coyne wrote in message <65qikc$gk6$1_at_heliodor.xara.net>...
>Has anyone used these two in conjunction ?

Yep.

>Is it possible to return a result set from a stored procedure ?

AFAIK it's not possible - but some say that it can be done with cursors or something. But even then it will not be nearly as flexible as stored procs in SQL-Server.

>Also using oracle through the bde. I'm using a large database with a
>million records and I need to insert inti the table quickly. The problem
 is
>it seems to take an eternity ( well two seconds). This is not fast enough,
>oh no !!! help !!!!

This all depends on how you configure Delphi and what drivers you're using. BDE support cached updates for example that can make a significant improve in performance. ODBC otoh is not a good choice most of the time. Also make sure that you're using SQL PASSTHRU - it's the SQLQRYMODE option in BDE (set it to server). Of course, the SQL statement(s) you're using to do an update also influences performance. After how many rows do you commit the transaction? Are you letting Delphi code the UPDATE statement itself via standard DB bound controls, or are you using the TUPDATESQL object (better choice) instead?

If you need to insert millions of records, any OLTP based SQL will give you problems. There are overheads in performance and diskspace on the DB server when doing a transaction. With Oracle's SQL*Loader you can do direct loads which bypasses any transaction-based processing. And loading a million odd rows can be done in minutes (depending on the hardware of course).

regards,
Billy Received on Mon Dec 01 1997 - 00:00:00 CST