Re: Design issue: Preload data or get on request

From: in (gunther_at_treeview.control)
Date: 03/04/05 

Date: Thu, 03 Mar 2005 17:16:07 -0800

Frustrated Newbe wrote:
> Hi,
>
> I would appreciate your opinion on the following issue. Suppose there is a
> windows (not web!) application that uses the data stored on an SQL server.
> There can be more than one concurrent user of the app, so the concurrent
> database update is an issue. There are also plenty of forms that when
> displayed have some or all controls pre-filled with data, which is stored in
> a number of different tables in the database. Question: what approach is
> better in this case - preload the data and store it in a dataset and only
> actually connect to the DB at the initial load and when insert/update is
> required or load the data for each user request and not maintain any cache.
> The number of records in question will be in hundreds rather than thousands
> and the app is designed to run on WinXP.
>

I'm working on the same problem right now.

The design I'm choosing is:

1. Use a web service to send the client an XmlDocument at first load.
2. Set up WSE 2.0 to send notifications of changes to the document to
the server and all the clients using messaging.
3. Occasionally refresh the database with the most current changes to
the XML document at the web service server.

Relevant Pages

  • Re: XML Transform
    ... same database. ... I have a table that has the XSLT and the information level ... we have 3 XSLT that we apply to the XML Document received). ... Is SQL Server ...
    (microsoft.public.sqlserver.xml)
  • Re: about structure.
    ... Of course if you want to use a load of checkboxes, it works too, just modify ... I thought about using a database... ... "I thought about using php... ... server needs to call upon php... ...
    (alt.php)
  • IIS Slowdown
    ... We are running IIS 5.0 on Windows 2000 server. ... The website is connected to a database, ... database can take over a minute to load. ...
    (microsoft.public.windows.server.general)
  • Re: Frequent use of attach and detach
    ... It doesn't solve our load farm goals. ... trying to avoid the bottleneck represented by the database server. ... assigning hardware to a database server is cumbersome for ASPs, ... Replication stands out to me as an obvious alternative to your ...
    (microsoft.public.sqlserver.server)
  • null value in xml translates to empty string in dataset after ReadXML
    ... I am importing data in a XML document into a SQL Server database. ... But when I load the XML document into a dataset, it becomes an empty string, ... I load the data into a XMLTextReader, read it into a dataset, and send it to ...
    (microsoft.public.dotnet.framework.adonet)