Board index » delphi » Remote Performance?

Carlos Matos

Delphi Developer
Mon, 04 Aug 2003 01:37:58 GMT

Remote Performance?

Hi to all,

I would like to know what components must I use to obtain the maximum
performance to connect to a remote host, because my company start making an
application (POS) for supermarkets that involve large databases.
Must I use IBX only, IBX with MIDAS, IBQuerys, IBDatasets, how should I do
this links, e.g., it is better to use a link like a IBDataset to a
TClientDataset, etc...

This is very important stuff to my company.

Regards,
Carlos Matos

 
Andres Allki

Delphi Developer
Mon, 04 Aug 2003 01:56:08 GMT

Re:Remote Performance?


ma...@comograma.pt (Carlos Matos) wrote in <3a8ac287_2@dnews>:

Quote
>I would like to know what components must I use to obtain the maximum
>performance to connect to a remote host, because my company start making
>an application (POS) for supermarkets that involve large databases.
>Must I use IBX only, IBX with MIDAS, IBQuerys, IBDatasets, how should I
>do this links, e.g., it is better to use a link like a IBDataset to a
>TClientDataset, etc...

From your description (many connections, large databases) I highly recommend
using IBX with MIDAS and implement some kind of connection pooling. When using  
MIDAS main difference between IBQuery and IBDataset is that with IBQuery you
can use constraints. Hope this helps a bit.

Andres

Carlos Mato

Delphi Developer
Mon, 04 Aug 2003 02:08:06 GMT

Re:Remote Performance?


So Andres,
Must I use a IBQuery or a IBDataset linked to a TClientDataset and connect
to the database with a IBDatabase. I don't have many experience on this
issue.

Thanks,
Carlos Matos

"Andres Allkivi" <and...@starsoft.ee> escreveu na mensagem
news:9048CCCECandresstarsoftee@172.21.1.4...

Quote
> ma...@comograma.pt (Carlos Matos) wrote in <3a8ac287_2@dnews>:

> >I would like to know what components must I use to obtain the maximum
> >performance to connect to a remote host, because my company start making
> >an application (POS) for supermarkets that involve large databases.
> >Must I use IBX only, IBX with MIDAS, IBQuerys, IBDatasets, how should I
> >do this links, e.g., it is better to use a link like a IBDataset to a
> >TClientDataset, etc...

> From your description (many connections, large databases) I highly
recommend
> using IBX with MIDAS and implement some kind of connection pooling. When
using
> MIDAS main difference between IBQuery and IBDataset is that with IBQuery
you
> can use constraints. Hope this helps a bit.

> Andres

Craig Stunt

Delphi Developer
Mon, 04 Aug 2003 03:01:38 GMT

Re:Remote Performance?


Quote
Andres Allkivi wrote:

> From your description (many connections, large databases) I highly recommend
> using IBX with MIDAS and implement some kind of connection pooling. When using
> MIDAS main difference between IBQuery and IBDataset is that with IBQuery you
> can use constraints. Hope this helps a bit.

        ...and Params.  ...and CommandText (though the latter should be
supported RSN).

        -Craig

--
Craig Stuntz               Vertex Systems Corporation
Senior Developer           http://www.vertexsoftware.com

Delphi/InterBase weblog:   http://delphi.weblogs.com

Patrick Len

Delphi Developer
Mon, 04 Aug 2003 03:44:01 GMT

Re:Remote Performance?


Quote
"Carlos Matos" <ma...@comograma.pt> wrote in message

news:3a8ac9bf$1_2@dnews...
Quote
> So Andres,
> Must I use a IBQuery or a IBDataset linked to a TClientDataset and connect
> to the database with a IBDatabase. I don't have many experience on this
> issue.

in a nutshell:
TClientDataset connects to a provider within your remote datamodule through
a connection that you have to pick.
then have the provider point to ibquery or ibdataset etc.
and of course those datasets need IBDatabase and IBTransaction.
hth
patrick

Quote

> Thanks,
> Carlos Matos

> "Andres Allkivi" <and...@starsoft.ee> escreveu na mensagem
> news:9048CCCECandresstarsoftee@172.21.1.4...
> > ma...@comograma.pt (Carlos Matos) wrote in <3a8ac287_2@dnews>:

> > >I would like to know what components must I use to obtain the maximum
> > >performance to connect to a remote host, because my company start
making
> > >an application (POS) for supermarkets that involve large databases.
> > >Must I use IBX only, IBX with MIDAS, IBQuerys, IBDatasets, how should I
> > >do this links, e.g., it is better to use a link like a IBDataset to a
> > >TClientDataset, etc...

> > From your description (many connections, large databases) I highly
> recommend
> > using IBX with MIDAS and implement some kind of connection pooling. When
> using
> > MIDAS main difference between IBQuery and IBDataset is that with IBQuery
> you
> > can use constraints. Hope this helps a bit.

> > Andres

Other Threads

1. Remote performance of Large Paradox DB

2. Interbase 5 (remote server) performance ??????

3. (TeamB) Remote connection PERFORMANCE problem

4. Jeff (TeamB) Remote connection PERFORMANCE problem

5. how remote are remote servers?

6. Delphi/Kylix performance compared to Java performance

7. Remote control & Debug remote components. (New home page)

8. Remote debugging with TDW help needed!!

9. Short-term, remote Pascal project

10. needed - code for remote diags s/w project