Re: database design for fast client updates

T.H.N. wrote:
I'm trying to work out a database design to make it quicker for my client
program to read and display updates to the data set. Currently it reads in
the entire data set again after each change, which was acceptable when the
data set was small but now it's large enough to start causing noticable
delays. I've come up with a possible solution but am looking for others'
input on its suitability to the problem.

Use stored procedures for your updates, inserts, deletes and selects.
As far as I can see you aren't doing that now. Is there a reason why
not?

If you use procs then you won't need the triggers, you probably won't
need two tables and you'll probably see a performance improvement along
with all the other benefits of procs.

Thanks for including the DDL. Always tell us what version you are using
as well - it does help.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

--

.

Relevant Pages

  • Re: Unique in-depth problem
    ... Standard date libraries don't work. ... Precompute all the dates and put them in a database (file, SQL server, ... a huge data set, yet manage to retrieve and show only the interesting ...
    (comp.lang.perl.misc)
  • Re: typed datasets and default values
    ... You could always extend the MSDataSetGenerator. ... would have to connect to SQL Server to get the default values for the ... columns in your data set, ... what you do is select the default values from the database for the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: International Access version problem
    ... > data set is correct or not. ... > formatting is used at form level that causes the problem. ... For 2 clients, however, they have a Danish Access installed and ... how do we get SQL server ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Please help quick statement check
    ... these two statements would get a complete data set. ... records which also have a recording match, and then i want to get all ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: database design for fast client updates
    ... program to read and display updates to the data set. ... I assume that these updates are not performed by your client program, ... Rather than using a datetime column, you could use a timestamp column. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)