Paradox/ObjectPal performance vs VB.net/Oracle

[teraB]

I am writing an vb.net application which will replace a legacy application written in ObjectPAL/Paradox. The problem is the performance issue. The old App is able to load the whole table(100,000 records) from Paradox database immediately. For the new vb.net App, it took about 7-10 seconds to load the same table from Oracle database. The users are reluctant to change to the new VB app. They complain the new App is too slow.

I have tested on oracle 9i, it took 2-3 seconds to query the whole table(100,000 records).(without output results)

When Paradox database loads the table, is it just open the db file? Why can it be this fast?

 

[TonyMcGuire]

I think you should ask this in a vb.net forum.

Sounds like a programming/technique issue rather than a Paradox issue.


Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[teraB]

I already post the same question in a vb.net forum. The reason why I post it here is because I want to know why Paradox/ObjectPal can be this fast. I need to know the pros and cons about Paradox. Thanks!