Subject | Re: Firebird on WIndows 2008 R2 |
---|---|
Author | siddharthparashar |
Post date | 2011-11-09T04:00:12Z |
--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
I doubled checked and these particular machines are not HP.
Also it's a single HDD with no RAID and does not support either read or write caching. I mean this particular model does not support this.
Another observation that we made is with transactions. Tae following example -
1> insert hundred records in a table
2> after each record is inserted, commit the transaction.
Now these steps give different output on different machines. On Windows 7 and XP they give results in 1.5 seconds.
But on Windows 2008 R2 this takes 22 seconds. Now when we changed the application to commit at the end or hundred inserts then output was almost same on both the machines.
Any thoughts on this?
Thanks,
Siddharth Parashar
>Thanks guys for your prompt response.
>
>
> > If it is HP, then you will probably have to enable HDD caching on RAID driver
> > ... even if you do not use RAID there is this option in HDD driver.
>
> As long as you are referring to activating READ caching, then that's fine.
>
> Activating WRITE caching without a protected controller cache will result in **data loss** if the system loses power, abends or is not shutdown properly.
>
>
> Sean
>
I doubled checked and these particular machines are not HP.
Also it's a single HDD with no RAID and does not support either read or write caching. I mean this particular model does not support this.
Another observation that we made is with transactions. Tae following example -
1> insert hundred records in a table
2> after each record is inserted, commit the transaction.
Now these steps give different output on different machines. On Windows 7 and XP they give results in 1.5 seconds.
But on Windows 2008 R2 this takes 22 seconds. Now when we changed the application to commit at the end or hundred inserts then output was almost same on both the machines.
Any thoughts on this?
Thanks,
Siddharth Parashar