> We are looking at POSSIBLY providing a solution for an Oracle database.
> Currently we use Interbase for all our solutions.
> Has anyone used Oracle via Delphi before...or currently....and if so, did
> you use some of the 3rd party Oracle tools availble, or how did you connect
> to it?
We use D4 to ORACLE7 and ORACLE8 via the BDE and SQL Links. The
comment from Antony about connection time is quite correct and is both a
relation of Computing power,network speed, network roundtrip - typically 2-10
seconds (more often towards the 2 mark)... It's not a serious issue and once
a cliet is connected there are no furthur slowdowns... ORACLE is very fast for
quite complicated queries (good at index optimisation), stable and quite
scalable... However it wants a lot of memory and does need a lot of work to
set up optimally - a qualified ORACLE DBA is definitely a must for real
performance tuning...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
