Re: AutoNumbers and ClientDatasets

Bill Todd wrote: 
Doing that would require a separate query for each new record. If the
user inserts 10 rows that would be 10 queries instead of 1.


The question is why would someone use Datasnap at first place. The main reason (IMO) is in case he would like to scale up to three- tier architecture in the future (in that case Access is not an option of course).

In a 3-tier design I believe (correct me if I am wrong) that it is more important to try to reduce network load between client app and middle tier, than it is between middle tier and database server. If that is the case, then reducing the number of calls to application server (through cds.Refresh) is more important than reducing the number of actual queries built from middle tier to the database server.
.

Relevant Pages

  • Re: FreeBSD, PostgreSQL, semwait and sbwait!
    ... > We're having a substantial problem with our FreeBSD 5.2 database server ... > queries per second), but queries are slow, and it's seemingly waiting on ... To unsubscribe, ...
    (freebsd-performance)
  • Re: Client-dataset-like components that work the same?
    ... Not an option - I'm not creating the queries nor the metadata. ... > middle-tier (which could be on the database server, ... Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Tweaking database performance
    ... If it's taking long time to connect to the database server, ... be some problems in the network. ... If the queries are taking long time to ... Prev by Date: ...
    (microsoft.public.sqlserver)
  • Re: FreeBSD, PostgreSQL, semwait and sbwait!
    ... > 5.2 database server ... > running PostgreSQL - it's getting a lot of traffic ... > queries per second), but queries are slow, and it's ...
    (freebsd-performance)