One quick thing that helped our program was to bring down only the fields that you need. DO NOT use the * in the Select statement.
>Hi there,
>
>I experienced slow performance in starting my program that
>uses SQL Server 6.5.
>What could be the posibilities of that cause? Pls advise.
>
>Thanks