1 vấn đề về thắt cổ chai

Hi Team, em dang co' issue nhu the nay
[3:06:32 PM] Le Anh Thu - DBA - HarveyNash: DB server response good
[3:06:48 PM] Le Anh Thu - DBA - HarveyNash: nhung websitre thi resopnse bad
[3:07:05 PM] Le Anh Thu - DBA - HarveyNash: nhung khi test tren cac trang it load db thi nhanh
[3:07:19 PM] Le Anh Thu - DBA - HarveyNash: nhung ~ trang load nhiue DB thi cham
[3:07:34 PM] Le Anh Thu - DBA - HarveyNash: neu query truc tiep tren DB server thi nhanh
[3:07:51 PM] Le Anh Thu - DBA - HarveyNash: co' cach nao chung minh mi`nh dang bi network bottle neck ko vay ca nha ui
[3:08:12 PM] Le Anh Thu - DBA - HarveyNash: client shoot mail keu explain ma` ko bit' cach nao tra loi cho em diu :(
[3:17:26 PM] Nguyen Anh Khoa - DBA - HarveyNash: ko biet truong hop cua anh giong cai em da tung gap ko
[3:17:39 PM] Nguyen Anh Khoa - DBA - HarveyNash: hoi xua em xai oracle/winform
[3:17:46 PM] Nguyen Anh Khoa - DBA - HarveyNash: chay tren mang cisco
[3:17:55 PM] Nguyen Anh Khoa - DBA - HarveyNash: load man hinh it data thi ok
[3:18:02 PM] Nguyen Anh Khoa - DBA - HarveyNash: man hinh nhieu data thi die
[3:18:19 PM] Nguyen Anh Khoa - DBA - HarveyNash: nhung ben IT chung minh la network chay rat nhanh
[3:18:26 PM] Nguyen Anh Khoa - DBA - HarveyNash: vi ho xai cap quang
[3:18:44 PM] Nguyen Anh Khoa - DBA - HarveyNash: copy data rat nhanh
[3:19:12 PM] Nguyen Anh Khoa - DBA - HarveyNash: va cuoi cung dieu tra ra
[3:19:21 PM] Nguyen Anh Khoa - DBA - HarveyNash: la do mang cisco
[3:19:48 PM] Nguyen Anh Khoa - DBA - HarveyNash: no co cho config dung luong cho data
[3:20:05 PM] Nguyen Anh Khoa - DBA - HarveyNash: sua lai cai do la ok
[3:23:03 PM] Nguyen Anh Khoa - DBA - HarveyNash: http://old.nabble.com/Cisco-ASA-firewall:-SQLnet-inspection:-buffer-limit-td21485169.html
[3:23:15 PM] Nguyen Anh Khoa - DBA - HarveyNash: SQLnet inspection

The solution:
nhung ~ trang load nhiue DB thi chamnhieu o day la bao nhieu Thu?
[3:36:00 PM] Hoang Vu Long - HarveyNash: neu tren web thi nen nghi den paging thoi
[3:36:15 PM] Hoang Vu Long - HarveyNash: web co ban no da khong giong win
[3:36:43 PM] Hoang Vu Long - HarveyNash: co the dung paging in procedure de limit record dua len web
[3:46:45 PM] Le Anh Thu - DBA - HarveyNash: dung nhu la Khoa noi
[3:46:56 PM] Le Anh Thu - DBA - HarveyNash: van de la do network bottle neck
[3:47:21 PM] Le Anh Thu - DBA - HarveyNash: em dang thuyet phuc client check network cua ho