Information générale
Titre:
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 on server.
What should I do to avoid “hangs”?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement