Environment versions
Network:
Windows 2003 Server
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only