| Subject | Slow query with a lot of fields |
|---|---|
| Author | Leonardo Cosmai |
| Post date | 2006-10-23T14:40:31Z |
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.
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.