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
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
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
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