| Subject | R: [IBO] BDE-to-IBO conversion: performance issues |
|---|---|
| Author | Enrico Raviglione |
| Post date | 2005-04-15T16:33:42Z |
Hi Jason,
i have a lot of different scenario:
- i have one query on a table with a large number of columns;
- i have a lot of queries on tables with only 3 or 4 columns (but if i
open all this queries at the same time i must wait a lot ...)
The problem (i think) are not focused on a specific operation.
I think there are something that must be speed-up or changed, as
metadata loading operation or some other operation that are executed at
opening time.
In my example (a very stupid program that open only a lot of queries)
you can see how long this operation are if you compare it with the other
example (who differ only for connection/query components).
My example are not only an example, but some datamodule or part of it
are extracted from a real application as i do for database tables. You
can see how in this database i have tables with a lot of number of
columns (and row...) and also a lot of very little tables.
Best Regards,
Enrico Raviglione.
-----Messaggio originale-----
Da: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Per
conto di Jason Wharton
Inviato: venerdì 15 aprile 2005 17.11
A: 'IBObjects@yahoogroups.com'
Oggetto: RE: [IBO] BDE-to-IBO conversion: performance issues
Ok, thanks.
Do you have tables or queries with large number of columns? There might
be something going on with this aspect of things.
Jason
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links
i have a lot of different scenario:
- i have one query on a table with a large number of columns;
- i have a lot of queries on tables with only 3 or 4 columns (but if i
open all this queries at the same time i must wait a lot ...)
The problem (i think) are not focused on a specific operation.
I think there are something that must be speed-up or changed, as
metadata loading operation or some other operation that are executed at
opening time.
In my example (a very stupid program that open only a lot of queries)
you can see how long this operation are if you compare it with the other
example (who differ only for connection/query components).
My example are not only an example, but some datamodule or part of it
are extracted from a real application as i do for database tables. You
can see how in this database i have tables with a lot of number of
columns (and row...) and also a lot of very little tables.
Best Regards,
Enrico Raviglione.
-----Messaggio originale-----
Da: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Per
conto di Jason Wharton
Inviato: venerdì 15 aprile 2005 17.11
A: 'IBObjects@yahoogroups.com'
Oggetto: RE: [IBO] BDE-to-IBO conversion: performance issues
Ok, thanks.
Do you have tables or queries with large number of columns? There might
be something going on with this aspect of things.
Jason
> -----Original Message-----________________________________________________________________________
> From: Enrico Raviglione [mailto:e.raviglione@...]
> Sent: Thursday, April 14, 2005 2:06 AM
> To: IBObjects@yahoogroups.com
> Subject: R: [IBO] BDE-to-IBO conversion: performance issues
>
>
>
> Hi Jason,
>
> i alwais set KeyLinks explicitly.
>
> Best Regards,
> Enrico Raviglione.
>
>
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links