Subject | skip metadata to increase remote speed? |
---|---|
Author | hkuser2001 |
Post date | 2002-11-28T06:56:24Z |
Dear all,
I am using IBO4.2Ib on WinXP. The server is Firebird 1.0 stable
release version (tried both Linux/ WinXP versions).
Connection to server with effective throughput of 512Kbps.
When I initially open a IB_Query which only needs to returns a few
rows, it takes up to 7 secs. Subsequent open is much faster, within
1 to 2 seconds. I used the monitor to find that, in the initial open,
most time is spent on getting metadata and table structure , like:
"SELECT S.RDB$FIELD_NAME ..."
Can I make the Query to skip this? Becuase sometimes I only want to
run a very simple query, I don't need these metadata. I am afraid my
client will not accept the initial delay.
Thanks.
Michael
I am using IBO4.2Ib on WinXP. The server is Firebird 1.0 stable
release version (tried both Linux/ WinXP versions).
Connection to server with effective throughput of 512Kbps.
When I initially open a IB_Query which only needs to returns a few
rows, it takes up to 7 secs. Subsequent open is much faster, within
1 to 2 seconds. I used the monitor to find that, in the initial open,
most time is spent on getting metadata and table structure , like:
"SELECT S.RDB$FIELD_NAME ..."
Can I make the Query to skip this? Becuase sometimes I only want to
run a very simple query, I don't need these metadata. I am afraid my
client will not accept the initial delay.
Thanks.
Michael