>Hi everybody,
>
>I type the ItemNo and using BL/DS I select info and then populate the textboxes on the form with the Information. This is very slow - looks like almost a minute before the info appears on the screen.

Are all SQL accesses that slow? I'd bet the problem is likely to be, for whatever reason, a slow SQL connect. Are you using Windows or SQL authentication?

>
>Was it the bad idea in the beginning to use DS/TA solution? I did add an index in Items table for ItemNo.
>
>Any way to make it quicker?
>
>Thanks in advance.