Dear Antony,
>Oracle databases tend to take a while to connect to so having a middle tier
that
> pools connections is a far more efficient method.
I have developed a TimeSheet system used internally in our company, just to
solve the problem that connect to database take a while, and no need to
install BDE on every client machine, the requirement of client just need to
install TCP/IP which including in every Windows 95 and NT system. Usually
connect to database if you use BDE will cost you 4 seconds depends on the
system, on my server I create multiple connections(currently the number is
8), so client connect to my middle tier(application server) just less than 1
second,.
>I am also thinking of the
> possibility of using the loadFromFile method of TQuery and store all the
> queries as text files (to get them out of the client).
I don't think you can manage to use normal TQuery component to load text
files. In Delphi 3(above) client/server, they got TClientDataset, which can
save special data format(MIDAS) to a file and load it. And I also develop a
component which can save and load text file format no need BDE or Microsoft
ODBC driver. We use it in a communiction project to offer thin client
solutions
Best Regards
Leigh Wanstead
----- Original Message -----
From: Antony Gardiner <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, March 02, 2000 9:28 AM
Subject: RE: [DUG]: Oracle and Delphi
> Hi,
>
> We have a good solution here using Delphi 1 (soon to be 5) and oracle 8.
It
> uses native oracle drivers and the BDE to connect to oracle. Currently all
> queries are performed using the TQuery object within Delphi and all
> transactions are performed within Oracle stored procedures. We use an
> application call T.O.A.D. This enables debugging of the PL/SQL stored
procs
> (other tools like this that are cheaper exist too I think).
>
> The main disadvantage of this method is that it is still basically a 2
tier
> architecture and there is at least one connection per client. Oracle
> databases tend to take a while to connect to so having a middle tier that
> pools connections is a far more efficient method. I am also thinking of
the
> possibility of using the loadFromFile method of TQuery and store all the
> queries as text files (to get them out of the client).
>
> Also I recommend not to drop TQueries and TStoredProc objects onto the
forms
> but instead create them dynamically in the source. It's easier to support
> afterwards.
>
> This application is now over 5 years old and it is going to be around for
a
> few more years yet. I am in the process of upgrading the application to
> Delphi 5 and add threads to enable the users to terminate queries if they
> take to long (currently they have to kill the app).
>
> Cheers Ant
> ________________________________________________________
> Antony Gardiner (IT Specialist)
> Clear Communications Ltd
> One of the Intranet, NRS, CPS, & NMS wannabes
> *+64 9 912 4746) Zone 1534
>
> -----Original Message-----
> From: Jeremy Coulter [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 2 March 2000 08:56
> To: Multiple recipients of list delphi
> Subject: [DUG]: Oracle and Delphi
>
>
> HI all.
>
> 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?
>
> Cheers, Jeremy Coulter
>
>
> Software Manager
> Triton Commercial Systems Ltd
> 6a Burdale Street
> Riccarton
> Christchurch
> pH 348 3973 fax 343 1613
>
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
