Performance and general questions

wam067 · Post by **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.

Plash · Post by **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.

wam067 · Post by **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.