Hi Jimmy,
OJB does prvide several optimizations to improve the most common lookups
like lookup by primary key, by foreign key etc.
OJB also provides association prefetching to optimize loading of 1:n
references.
But there is no special optimization of sql statements in the SQL
generator. OJB does provide a pluggable sql-generator. SO if there
should be any deficits in or sql generation it could be replaced with an
optimized generator.
Some users did so to allow usage of stored procedures.
cheers,
Thomas
PS: Please don't contact developers directly, always use the official
mailing lists. By using mailing list much more people can benefit from
questions and answers.
Jimmy Tong wrote:
> Hi Thomas, my name is Jimmy. I was referred to you by Christian
> regarding the issue mentioned in the mail below. Please advise.
> Thanks
>
>
> Jimmy Tong
>
> -----Original Message----- *From:* [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] *Sent:* Saturday, January 04, 2003 11:47 PM
> *To:* [EMAIL PROTECTED] *Subject:* AW: SQL optimization in OJB
>
> Hi Jimmy,
>
> since 7 month's I have nothing do with ojb. I can rember that there
> where some mechanism. So I believe that the prepared statement for a
> table where build only one time. I think it is better if your ask
> someother of the team. I think Thomas Mahler is one who know's it.
>
> good luck Christian
>
> -----Urspr�ngliche Nachricht----- *Von:* [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] *Gesendet:* Donnerstag, 2. Januar
> 2003 16:56 *An:* [EMAIL PROTECTED] *Betreff:* SQL
> optimization in OJB
>
> Hi Christian, my name is Jimmy, from Singapore. I recently downloaded
> the OJB to test run on my application. I have a question:
>
> Does OJB do any SQL optimization at the backend?
>
> What are the mechanism used to ensure the SQL is constructed
> efficianly?
>
> Thanks Jimmy Tong Singapore
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
