[firebird-support] How can you change the transaction level to READ_ONLY in SQL

2011-10-28 Thread dsaunders1971
Hello, I have tried this sort of syntax but just get a dynamic sql error SET TRANSACTION READ ONLY; select * from Booking What's the full and proper format for this? Thanks in advance

[firebird-support] Re: Why does Firebird write so much data for simple select queries?

2011-10-28 Thread dsaunders1971
the resultset on HDD when SELECT contains ORDER BY (maybe PLAN SORT affect that), and does the ordering in this file. --- In firebird-support@yahoogroups.com, Ann Harrison aharrison@ wrote: On Thu, Oct 27, 2011 at 11:11 AM, dsaunders1971 dsaunders1971@wrote: I have a question about why

[firebird-support] Why does Firebird write so much data for simple select queries?

2011-10-27 Thread dsaunders1971
I have a question about why Firebird writes / or changes so much data in the database file when you run a simple select query. What data is it changing in the database? Can this behaviour be modified /turned off via configuration? When I run the select statement in IB Expert it tells me nothing

[firebird-support] Re: Firebird performance issues on VM platform

2011-10-27 Thread dsaunders1971
Hello, This is of great interest to me since we are just about to do the same thing. I have been doing some analysis of the IO on our current production windows 2003 servers. I have discovered something quite alarming that may explain why you are getting poor performance on a VM I looked at