Performance and general questions

Performance and general questions

Postby wam067 » Fri 13 Mar 2009 18:42

I am interested in utilizing my CodeGear Delphi 2007 for win32 to access large amounts of data in Oracle. We currently use BDE compoents which seem to work fine but we want to explore moving off of the BDE environment which seems to use quite a bit of memory. I would like to know what general reccomendations you would make on what Devart products would be best suited for our shop (4 developers) and what Devart DB access component libraries would offer us the best performance when needing to return large data sets of 100000 to 200000 rows with many fields. We have tried the native dbexpress and were quite underwhelmed with its performance. Is Devart DBexpress the best choice? or should we consider Devart ADO or perhaps some other db access component libraries? Let me apologize in advance for my lack of details and coding expertise. At this point, any info at all would be helpful and very much appreciated.
wam067
 
Posts: 5
Joined: Fri 13 Mar 2009 18:29

Postby Plash » Thu 19 Mar 2009 09:07

Devart dbExpress driver has approximately the same performance as the standard CodeGear driver.
We recommend using our ODAC or UniDAC components for the best perfromance and stability.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby wam067 » Thu 19 Mar 2009 15:28

Thank you for the info. I have downloaded the ODAC and it's performance is even a bit faster than BDE. I believe this will be a perfect solution for us.
wam067
 
Posts: 5
Joined: Fri 13 Mar 2009 18:29


Return to dbExpress driver for Oracle