Performance issue in PB10

[tabhijit]

Hello everyone,

We just now migrated our application from PB8 to Pb10. Our application have 2 databases.
1) Oracle
2) SQL Anywhere which is available on every PC.

Data is cached in local database when application starts.

We have one function which performs below operations.
1) check all columns in datawindow.
2) Check if dddw is attached to column.
3) If yes then get SQL of dddw.
4) Get Table name by selecting SQL between FROM and Where.
5) Trim all white characters and get table name.
6) If table is present in local database then change transaction object and make dddw point to local database instead of Oracle.
7) Retrieve dddw.

I suspect that this code is taking lot of time in PB10 as compared to PB8. When I removed the above function and changed transaction object of specific dddw by hard coding loading time came down to 20 sec from 4 min.

Mean while I will use trace option to track exactly which event/function is taking more time to execute.

Is PB10 slower than PB 8? Is this general behaviour of PB10 ?

Thanking in advance

Abhijit.