First, you could try increasing the time out: Server.ScriptTimeOut = n
If the problem continues, you could try changing the order of the fields and
put Login as the first one, with the apropriate index. I've done it with
Access and it worked just fine.
I hope this helps you.
Fernando
MyWay ISP
-----Mensagem original-----
De: CPD- Jr <jr@ceub.br>
Para: radiusnt@iea-software.com <radiusnt@iea-software.com>
Data: Terça-feira, 25 de Agosto de 1998 16:03
Assunto: 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