At 07:46 PM 30/10/2008, you wrote:

>> Certainly it will take some time to prepare 150 fields. But surely
>you are only preparing once in a session? Perhaps you need to show us
>what you are actually doing in your code...
>>
>> Helen
>>
>
>Tks Helen for the aportation, but the application have about 200 query
>in diferents forms, if I create and prepare all the forms/querys may
>be the aplication must start while prepare the coffe ... kidding.

I hope so! I did not suggest that you prepare 200 queries at once. Only prepare a query if it is used, but prepare it once only in the session.

>No way.
>Every form have some specific querys, some complex, but I tested and
>REALLY the complexity its not a matter, if only take a fied from every
>table, the prepare is so fast (less than a second).
>But when 150.. things are very diferent.
>Tip: If I disconect the tib_datasource from tib_query (for disconect
>and isolate all edit fields in the form) the time its... pretty the
>same... it's not depend of number of fields in the form, but the
>fields fetched in the query.

I am not surprised. ;-)

./heLen