ODBC: DSN bandwidth limit?

[Taskman]

I have a foxpro 6.0 DSN and a SQL DSN. The foxpro DSN is pulling data from across a 1 gigabit network to the destination SQL DSN. I am trying to find ways to speed this up but want to know the bottleneck. Right now the process to move the data is run on a single server. If I were to run the process on two servers that would mean two Foxpro DSNs would be sending data to the single SQL DSN. Would the SQL DSN be able to handle this? Thanks

Warren

 

[mikej336]

I'm a little confused... I don't know of an situation where you have two DSN's that connect together.

You would only need 2 DSN's if both Foxpro and SQL where acting as Client and Server and even then the DSN don't connect together. They connect either Foxpro to SQL DSN or SQL to Foxpro DSN.

If you are running on Gig eithernet adapters your probably going to find that the bottleneck is probably your hard drives. Deviding your databases on 2 servers might help.

Uncle Mike