Performanve Issue-Datasets in VB.net

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
---
Posted via DotNetSlackers.com

William
Fri Nov 24 14:25:18 CST 2006

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)
-----------------------------------------------------------------------------------------------------------------------

<Kashif> wrote in message news:%2318OP3%23DHHA.4832@TK2MSFTNGP06.phx.gbl...
> 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
> ---
> Posted via DotNetSlackers.com

Cor
Sat Nov 25 03:05:07 CST 2006

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

<Kashif> schreef in bericht
news:%2318OP3%23DHHA.4832@TK2MSFTNGP06.phx.gbl...
> 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
> ---
> Posted via DotNetSlackers.com

Miha
Sat Nov 25 08:11:44 CST 2006

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/

"Kashif" wrote in message news:%2318OP3%23DHHA.4832@TK2MSFTNGP06.phx.gbl...
> 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
> ---
> Posted via DotNetSlackers.com

William
Sat Nov 25 11:47:54 CST 2006

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)
-----------------------------------------------------------------------------------------------------------------------

"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:OXE3ICHEHHA.3188@TK2MSFTNGP06.phx.gbl...
> 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
>
> <Kashif> schreef in bericht
> news:%2318OP3%23DHHA.4832@TK2MSFTNGP06.phx.gbl...
>> 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
>> ---
>> Posted via DotNetSlackers.com
>
>

Kashif
Mon Dec 04 11:32:59 CST 2006

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

---
Posted via DotNetSlackers.com