SQL Timing Out

CPD- Jr ( jr@ceub.br )
Tue, 25 Aug 1998 15:50:00 -0300

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Brian Lube: "Re: Radius / SQL question for Calls Table"
Next message: Fernando Lessa Pesa Filho: "Re: SQL Timing Out"
Next in thread: Fernando Lessa Pesa Filho: "Re: SQL Timing Out"

Hello All,
The Calls table has more than 10Mb for less than 30 days, I'm trying to
make an asp to show time online per user, but the query is taking too
long and SQL is timing out.

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired

Any idea how to solve it ?
TIA,
JR

Previous message: Brian Lube: "Re: Radius / SQL question for Calls Table"
Next message: Fernando Lessa Pesa Filho: "Re: SQL Timing Out"
Next in thread: Fernando Lessa Pesa Filho: "Re: SQL Timing Out"