Performance and general questions
Posted: 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.