Question Is it possible to make a desktop app that uses internet infrastructure?

[motorola]

Hi,

Normally desktop apps connect to the database server via LAN. I want to make a desktop app (winforms) that can utilize internet connection as the data transfer media. After all, there's not much difference in the data transmitted through LAN or internet right? the electric signals are transmitted through the same type of cable. thanks

 

[cjard]

True. Bothyour LAN and the internet push data round using TCP/IP

When writing apps that use a database over the internet, bear in mind that it is very slow and typically the electricity takes hundreds of milliseconds more time to get there and back.. THis doesnt affect data flow rate so much but it has massive impact on response time. If you app runs 1000 qieries one after the other.. on a lan it's 1000 * 1ms = 1 second to complete.. On the net with a ping of 200ms to the server in another country, it's 200 seconds to run ur queries i.e. 3.5 minutes.. versus 1 second.. its a big diff. Leave the data in the db as much as possible. Use stored procedures a lot