>Hi;
>
>I have a small network of WinXp machines running on a Win2003 server. There is no SQL server. My application resides on a share on the server, and we run it from a shortcut on the desktop. The database and the tables reside on the same share as the application.
>Queries take a very long time to complete when running through the network. A query that takes under a second to complete locally, would take 10 seconds to complete through the network.
>
>My question (Finally): Is there a trick to solving this problem without going client-server? I would like to continue using SQL commands, but I may need to create cursor and then seek and populate the cursor manually (This is very fast even through the network).
>
>Thank you all,
>
>Alen.
Alen,
I saw almost the exact same question on another forum (but where I don't remember), there you gave your indexes and SQL, and seek, populate code. While your seek version was using proper indexes SQL version were not using an index. Still it is a huge difference from 1 to 10 secs. I'd supecet hardware as well.
Cetin