How can we use shared mssql database in windows application?

vimal patel

12y1.6kSQL

I have created windows form application and I want to use live ms sql database(shared hosting ms sql database) instead of local ms sql server database. I have made connection using below connection string:
Data Source=seevername;Initial Catalog=databasename;Persist Security Info=True;User ID=userid;password=password;
with live ms sql database but it's respond is too slow.
Is there any way to communicate fast with live ms sql database?
Thanks in advanced.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Steven Reid12y ago
Hi Vimal, You may try your shared hosting speed by browse your Control Panel? Is it fast? If yes, then you need to optimize your DB too.
0
Nitesh Kejriwal12y ago
It mostly depends on your bandwidth and also the time taken by the server to respond to your request. However, you can improve your query performances by creating indexes, stored procedures so that the DB is optimized for use. Please contact your hosting provider for further improvements.
0