Performanve Issue-Datasets in VB.net

[Kashif]

I'm using datasets in vb.net to pull the data from MSDE server. I refresh the data from server every 30 seconds. Since, i refresh the data i clear the dataset using dataset.clear and then fill it again. This clear method each time seems to be increasing the delay to refresh data. My dataset has information from 4 tables with relationships
Also, when i save the data in database and then refresh the datasets that also keeps increasing the time delay. I'm not sure what else to do as this application is running in a multiuser enviorment and i need to refresh data on 3 PCs running the same applcation

Any advise on how to tackle the problem

Regards
Kashif

 

[William \(Bill\) Vaughn]

Create a server-side Keyset cursor? This way the data remains on the server
and does not have to be transported to the client, stored in memory and torn
down when the process repeats. See the Appendix in my book on how to do this
using ANSI cursors.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)

 

[Cor Ligthert [MVP]]

Kashif,

Strange Bill is not saying this, try to change your MSDE server for a
SQLExpress or a Compact SQL server. (If you want to know more about that,
reply, although Bill has fullfiled this newsgroup with (good) information
about that one).

Cor

 

[Miha Markic [MVP C#]]

I would try to find the bottle neck using a memory profiler (AQTime
perhaps).
Other than that you could create a new dataset instance each time rather
then calling Clear().
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

in message news:%2318OP3%[email protected]...

 

[William \(Bill\) Vaughn]

Cor, "upgrading" to SQL Express won't help, but building a local data store
with SQLCe just might--and use replication to keep them in sync. But that
would require that the customer pay for SQL Server. Replication requires
Workgroup or better...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)

 

[Kashif Khan]

Hi Bill,
You mentioned about the server side ANSI cursors, i'm not able to get more information on them with your book. Is there a way can you send me the example on how to accomplish this solution?

Thanks