Skip to Content
0

DW slower on runtime than on IDE

Oct 18, 2017 at 01:54 PM

61

avatar image
Former Member

Hi guys, I've seen this question asked a few times, but I haven't found an answer that solved my problem.

I have a dw that takes 10 seconds to start retrieve and an extra 5 seconds to finish retrieving all the rows (total 15 seconds), on a PB 12.5 IDE.

When I put this DW on a window, and retrieve it on runtime, it takes instead 32 seconds to retrieve.

It's a local MySQL server, no network involved.

Things I've done:

1. Copied/pasted the dbparm from the PB IDE, so that both are the same. It's a MySQL DB;

sqlca.dbparm="ConnectString='DSN=CIV;UID=root;PWD=XXX;database=mydb',DelimitIdentifier='No',CallEscape='No',OJSyntax='ANSI'"

2. I've created a new window, with a new DW control. No scripts on either of it, except the settransobject and retrieve;
3. I've tried creating a new dw, copying and pasting the original query. In this new dw I didn't put any computes or anything, just let the layout be as PB generated it. I always use syntax mode;
4. SetRedraw(False)...
5. The retrieval arguments are the same... same 9500 lines returned.


Any ideas for what else I should try?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 25, 2017 at 08:38 PM
0

Hope It is because of query. Did you run the same query some other sql client and sees how much time it takes. If both taking more less same time and you need to see what is problem in query

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 26, 2017 at 08:24 PM
0

Try setting DisableBind=1 in your connect string. In my case, there was a significant increase in performance.

Share
10 |10000 characters needed characters left characters exceeded