Re: Client-dataset-like components that work the same?

From: Martijn Tonies (m.tonies_at_nospam-upscene.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 00:09:44 +0200

Hi Martin,

> Several answers come to mind:
> - use stored procedures in case you want to manipulate the data (what
would
> otherwise be the point to retrieve all those records)

Not an option - I'm not creating the queries nor the metadata. Read my 2nd
reply to Kim for a more detailed explanation.

> - use a dedicated 3rd party driver on some relevant SQL (www.crlab.com has
> several without the overhead usually involved)
> - use something like dataabstract from remobjects, do the processing on
the
> middle-tier (which could be on the database server, makes network traffic
a
> non-issue)

See above :-)

> By the way, any chance of Oracle being supported in your database
workbench?

Yes. Work for this should start soon. 

-- 
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

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: AutoNumbers and ClientDatasets
    ... In a 3-tier design I believe 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. ... then reducing the number of calls to application server is more important than reducing the number of actual queries built from middle tier to the database server. ...
    (borland.public.delphi.database.ado)
  • 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)
  • ultrasearch: transfer metadata from one instance to another
    ... In the course of switching to a newer database server we also want to ... transfer ultrasearch to this new server. ... I'm reluctant of having to ... How could I accomplish a complete transfer of all metadata ...
    (comp.databases.oracle.server)