General information
Title:
How can we avoid “hangs”?
How can we avoid “hangs”?
The situation is: There is a client-server application. Client is Visual Fox Pro 6.0 sp 4
Server is MSSQL 7.0. Server is Celeron 400, it’s memory is 196 MB. The example of the code is
_cliptext = "select bl.cntr_num, p.pers_nm, bui.bui_adr,bui.bui_n,bl.square,bui.build_id, bl.bl_id,bl.y_debt,bl.yf_debt,bl.y_dat,bl.pay_dat as pay_dat1,bl.fine_val,p.pers_adr" + " " +;
"from b_lease bl, person p, build bui where bl.build_id *= bui.build_id and bl.pers_id *= p.pers_id order by cntr_num"
= SQLEXEC(Handle,_cliptext,'cursor_contract')
…………………………………………………..
SELECT cursor_contract
USE
…………………………………………………
_cliptext = 'SELECT * from vw_b_lease where cntr_num = ?lccntr_num'
=SQLEXEC(Handle,_cliptext,'b_lease')
Usually 12 users work at the same time. Periodically users “hang”.
It was noticed the more queries users do in the same connection the more memory is used.
What should I do to avoid “hangs”?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only