Hello, > The client does fetch the resultset row by row. The Time sould be > determined more by the size of result than by the complexity of query.
Is this actually true? I just ran a test, remotely (through an internet link) connecting to a database on a firebird 2.5 server, and I ran a wireshark dump while performing simple select statements. I used a simple demo (can provide source if requested) written in Delphi using dbexpress. I could read about 5500 records (3 varchar columns, total of 59 bytes per row) with around 580 tcp packets. Stepping through the source, a request for the next row (assuming no more data available) would bring about 6/7 new rows from the server in a sigle tcp fragment. Don't know if this is a compression on the TCP stack (Nagle & similar techniques), a feature from dbexpress or if it's the actual firebird protocol. Don't know if running the connection over a VPN would change the results. Also, is there any work under way to provide compression and encryption to firebird connections? Thanks. -- Matheus Degiovani Gigatron Software e Treinamentos Ltda. (18) 3649-4045 MSN: [email protected] -- CrĂticas ou Sugestões? Ligue para Ouvidoria Gigatron: (18) 3649-4048 ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
