Re: [firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
Not sure if Firebird performs in s standard way related to filesystems, but I've found a good report about databases and filesystems on Linux: http://highlandsun.com/hyc/mdb/microbench/MDB-fs.ods Maybe it can help. Regards! El 07/11/2012 01:51 p.m., mariuz escribió: --- In firebird-support@yahoogroups.com, W O sistemas2000profesional@... wrote: And what about Ubuntu Server? What do you think, is it good for Firebird or not? I have no issues with Ubuntu stable and Debian on servers Choose the ext4 by default without modifications , only if you hit the large inserts issue mentioned in the article is worth tuning the parameters but in the rest is better to leave the ext4 settings by default or else the os can't guarantee the write on the disk (that is the durability in the ACID) The ext4 can be as good as XFS but is better to test it in your own workload http://www.ibphoenix.com/resources/documents/search/doc_26 In the end it depends if you want the data safe or if you need the speed http://www.firebirdnews.org/?p=6457 So reliability have a real cost hard to have perf and reliability ++ 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 -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446- int. 103 Correo electrónico: jbrug...@dasu.com.ar Website: www.dasu.com.ar
Re: [firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
And what about Ubuntu Server? What do you think, is it good for Firebird or not? Greetings. Walter. On Wed, Nov 7, 2012 at 2:46 AM, trskopo trsk...@yahoo.com wrote: ** --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: FB has VERY poor performance with EXT4 http://www.firebirdnews.org/?p=6421 Hi ma_golyo, Thanks for the tip. After I read that article, if I am not mistaken, Barriers setting in ext4 cause poor performance. Do you know if I set Barriers to off and No Journaling mode in ext4 will improve significant performance? Ask because ext4, do has some advantage such as Multiblock allocation. Regards, Sugiarto [Non-text portions of this message have been removed] ++ 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
W O wrote: And what about Ubuntu Server? What do you think, is it good for Firebird or not? Since the core stuff is the same on all distros 'which is better' is somewhat academic. I'm running a number of machines 'command line only' over ssh at remote sites so the bulk of the differences with desktop set-up do not apply. Some of the machines I've never seen except over the wire and I'd rather than Linux in that case. It *IS* all just a matter of what else you need to run. In my case the latest Apache and PHP are not currently supported on a stock SUSE set-up, so I'm switching newer machines to Fedora 17 which does. Firebird has a little better support on both so if you don't need the rest it's not so critical. Ubuntu is another base that is still on the last major release of Apache and PHP. No doubt someone will say 'Manually install', but this introduces a lot of other problems when the distro has 'it's own way of working' even Firebird files end up in different places and can pick up old versions if they are not removed properly. The comment that 'there are more pitfalls' is perfectly correct, but at least managing them is somewhat easier than tracking a dodgy update on Windows ;) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Re: [firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
Hello, trskopo! Wednesday, November 7, 2012, 9:29:05 AM, you wrote: t 1) What drivers in that should exist for better performance? My t guest is CPU and Harddisk, is this correct? yes. But even you buy brand hardware, drivers can be bad in performance. t 2) Assuming that Linux and windows has correct drivers, which one is better? It can be understood only by test. Linux is much specific, as I said. For example, on some hardware Linux (CentOS) was 30% slower than Windows (for FB Classic with ~400 active connections). 2. You can choose linux distro by your preferrence. If you don't know any Linux well, then, you will have troubles. t I am thinking using CentOS or Suse, what distro do you use for yours? I do not use Linux :-) but our clients - use latest CentOS and Suse. -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
Hi Lester, Thanks for your reply. So the question should perhaps be ... what are you using with Firebird? I am using firebird in client-server environment for accounting application and mostly only in a LAN. About file system, (if I didn't mistaken) someone here mentions not to use specific file system, because it will decrease firebird's performance. Regards, Sugiarto
Re: [firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
trskopo wrote: Thanks for your reply. So the question should perhaps be ... what are you using with Firebird? I am using firebird in client-server environment for accounting application and mostly only in a LAN. About file system, (if I didn't mistaken) someone here mentions not to use specific file system, because it will decrease firebird's performance. To be honest I'd like a definitive answer here. Since I'm storing a large tree of folders with other content on the same disk it's a different case to dedicating a single disk to store just the database. All of my machines are idle for a large part of the day. Just need speed to get a fast response when several enquiries come in at once, so I've not had to worry. If I start getting to a point where database access is a problem I'd probably simply move the database to it's own Linux box and run the database on it's own disk, at which point I'll be asking the same question :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
FB has VERY poor performance with EXT4 http://www.firebirdnews.org/?p=6421 --- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote: trskopo wrote: Thanks for your reply. So the question should perhaps be ... what are you using with Firebird? I am using firebird in client-server environment for accounting application and mostly only in a LAN. About file system, (if I didn't mistaken) someone here mentions not to use specific file system, because it will decrease firebird's performance. To be honest I'd like a definitive answer here. Since I'm storing a large tree of folders with other content on the same disk it's a different case to dedicating a single disk to store just the database. All of my machines are idle for a large part of the day. Just need speed to get a fast response when several enquiries come in at once, so I've not had to worry. If I start getting to a point where database access is a problem I'd probably simply move the database to it's own Linux box and run the database on it's own disk, at which point I'll be asking the same question :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Re: [firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
ma_golyo wrote: FB has VERY poor performance with EXT4 http://www.firebirdnews.org/?p=6421 So are most things which is why I make sure that I'm still using EXT3 ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
André Knappstein [2012-11-06 12:44] : That's a welcome thread and I would like to jump it, because I have the sameinterest/question. I don't want to spam the support list, so please, what's the best place to ask for available (paid) services around Firebird/Linux combinations? We are talking about a middle-sized company here. 50 seats. www.ibphoenix.com ++ 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
Hi Dmitry Kuzmenko, Thanks for your reply. 1. Windows can be better or slower than Linux on same hardware, depends on hardware and existing drivers for hardware for Linux and Windows. Difference can be up to 30% of performance. 1) What drivers in that should exist for better performance? My guest is CPU and Harddisk, is this correct? 2) Assuming that Linux and windows has correct drivers, which one is better? 2. You can choose linux distro by your preferrence. If you don't know any Linux well, then, you will have troubles. I am thinking using CentOS or Suse, what distro do you use for yours? Regards, Sugiarto
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
--- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: FB has VERY poor performance with EXT4 http://www.firebirdnews.org/?p=6421 Hi ma_golyo, thanks for the tip. Sugiarto
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
--- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: FB has VERY poor performance with EXT4 http://www.firebirdnews.org/?p=6421 Hi ma_golyo, Thanks for the tip. After I read that article, if I am not mistaken, Barriers setting in ext4 cause poor performance. Do you know if I set Barriers to off and No Journaling mode in ext4 will improve significant performance? Ask because ext4, do has some advantage such as Multiblock allocation. Regards, Sugiarto