Subject Re: Slow query with a lot of fields
Author paulruizendaal
What is the type of field48? If it is a long varchar, a blob or an
array, it may be that a lot more data has to be transferred than for
field 1 to 47.

--- In firebird-php@yahoogroups.com, "Leonardo Cosmai"
<leonardo.cosmai@...> wrote:
>
> Hi,
>
> I've this query "SELECT field1, field2, ..., field47 FROM table",
the
> time spent by ibase_fetch_row (first row) is 0.002 ms.
>
> If I add a single field ("SELECT field1, field2, ..., field47,
> field48 FROM table") than ibase_fetch_row grows at 0.042 ms.
>
> Test with various field's combination.
>
> Any ideas?
>
> PS: maybe it depends on firebird and not from php.
>
> Ciao
> L.
>