Archives of the TeradataForum
Message Posted: Mon, 30 Aug 2004 @ 15:56:14 GMT
Subj: | | Multiple calls to database |
|
From: | | Ferry, Craig |
I am seeing multiple duplicate calls (hundreds to thousands of repeats) to our database with SQL statements like the following. I believe some
of these may come from ASP pages or VB applications that use drop down list boxes.
Has anyone else encountered this problem?
SELECT T2.branch_id ( SMALLINT ) , T2.region_id ( INT )
FROM dss_tables.branch T2
WHERE ( T2.branch_id = ? )
AND ( T2.region_id = 8150 )
ORDER BY T2.branch_id
Thanks
Craig
________________________________
Craig Ferry
Database and Unix Administrator
WESCO Distribution, Inc.
|