response time

[eaburk]

When accessing pages through the browser on static pages response time is great.

If I add some php code to connect to the database (i5_connect) response time becomes terrible (up to 7 seconds to load a small page) and events are generated with the following text:

Severe Slow Request Execution (Absolute)

I can get better response time by using i5_pconnect but why is connecting to the database so resource intensive?

[chris_hird]

I just created a page which uses the i5_ functions and found the same problem, its terribly slow! I then created a similar prgram using the db2_ functions and it flies through! I have a problem because I want to be able to store the row number with each record, i5_bookmark is great but there is no db2_ function I can find that provides the same functionality??

Chris...

[zend_i5]

The connection process in in the Toolkit is the reason for slow response time. Use persistent toolkit connection function i5_pconnect() http://files.zend.com/help/Zend-Server-IBMi/i5_php_connector_api.htm#MiniTOCBookMark2
to improve an overall Toolkit response time.

[chris_hird]

Tried that and the response time is still 6-7 seconds where as the db2 connections take subsecond? Any other ideas?

Chris...

[chris_hird]

OK it is faster! I am using studio which seemed to save the file but didn't! I had no errors so when I ran the request again it was just as slow as before. I was looking for another function and when I re-opened the file it still showed the old i5_connect() function not 15_pconnect() as it should! I changed to i5_pconnect() again, saved and now it is running much faster! Studio does seem to be a bit flaky at times? I am running it on Widows7 64bit which could be part of the reason.

Chris...

[eaburk]

Why is the toolkit connection process so intense?

If I use i5_connect throughout my application it would become unusable.

[zend_i5]

Make sure to use i5_connect() function once in the script and each i5_connect() function should have i5_close(). To improve the Toolkit performance use persistent connection i5_pconnect() http://files.zend.com/help/Zend-Server-IBMi/i5_php_connector_api.htm#MiniTOCBookMark2