RE: RE: Platform vs. Performance
I'm running 1Gb on my normal desktop with XP pro...it's sufficient, but just, if you've got swap disabled. Still gets bogged down sometimes, almost like it's trying to swap and getting frustrated because it's not allowed to. I'd be happier with 1.5 or even 2Gb of nice hot DDR333...these days, ram is cheap enough you can really load up a machine and not hurt too much. D -Original Message- From: Jeremy Proffitt [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 8:46 PM To: Mysql List Subject: Re: RE: Platform vs. Performance First, Thanks for all replies, I'll be going with XP Pro on a P4 machine. The next question is RAM, I know more is better, but the access database file I'm using now is 120Megs and will stay about the same size. Do I need more than 1G, can I get by with 512M Ram? I will of course turn virtual memory off and will also be using this computer for file sharing and burning cd's as backup's - or using a tape drive. Thanks Again! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RE: Platform vs. Performance
First, Thanks for all replies, I'll be going with XP Pro on a P4 machine. The next question is RAM, I know more is better, but the access database file I'm using now is 120Megs and will stay about the same size. Do I need more than 1G, can I get by with 512M Ram? I will of course turn virtual memory off and will also be using this computer for file sharing and burning cd's as backup's - or using a tape drive. Thanks Again! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Platform vs. Performance
Harald, How often do you read 200 rows by key in a daya to day application? How often do you insert 350768 rows in an application that you're considering Win98 as the platform? I've never deployed MySql on Wintel, except for developing on my laptop. I always use Solaris or Redhat for serious deployments. However, Wintel was the best platform for the deployment we were talking about because that was where the experience lay. It doesn't need *nix - it's only replacing a tiny little access dastabase... Don't get so hung up on your platform preaching that you forget your sense of reality... Andy > -Original Message- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs > Sent: 18 September 2003 17:00 > To: [EMAIL PROTECTED] > Subject: Re: Platform vs. Performance > > > In article <[EMAIL PROTECTED]>, > "Andy Eastham" <[EMAIL PROTECTED]> writes: > > > I don't see anything in there that is relevant to the original posting. > > Andy > > >> The following URL tells you that there's a big difference between > >> Windoze and Linux: > >> > >> http://www.mysql.com/information/presentations/presentation-oscon2 > > 000-2719/index.html > > Speed difference between different SQL servers (times in seconds) > > Reading 200 rows by key:NT Linux > mysql 367 249 > > Inserting (350768) rows:NT Linux > mysql 381 206 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Platform vs. Performance
Are these numbers still valid? Those documents are quite old - well before the time of 4.0 being declared production ready and before the inclusion of InnoDB tables. Since then, the Windows port has had a lot of work done on it and many of the "TODO" sections at the bottom have been taken care of. In other news, Windows is a hideous OS and should be avoided for all server duties, unless your only alternative is made by SCO. Regards, Chris On Fri, 2003-09-19 at 01:59, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > "Andy Eastham" <[EMAIL PROTECTED]> writes: > > > I don't see anything in there that is relevant to the original posting. > > Andy > > >> The following URL tells you that there's a big difference between > >> Windoze and Linux: > >> > >> http://www.mysql.com/information/presentations/presentation-oscon2 > > 000-2719/index.html > > Speed difference between different SQL servers (times in seconds) > > Reading 200 rows by key:NT Linux > mysql 367 249 > > Inserting (350768) rows:NT Linux > mysql 381 206 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Platform vs. Performance
Alec, My point was that in a 40,000 row database, server speed is irrelevant - it's going to be sub second on anything more powerful than my mobile phone. Cost of ownership is much more important for this application, and that depends on the particular circumstances. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 18 September 2003 14:53 > To: [EMAIL PROTECTED] > Cc: Mysql List > Subject: RE: Platform vs. Performance > > > > > > > I don't see anything in there that is relevant to the original posting. > > The tables headed "Speed difference between different SQL servers > (times in > seconds)" > > The top row of each table shows times for the same operation on Linux and > Windows, showing that for both operations tested, Linux achieves > 50% better > throughput (takes 2/3 of the time). > > Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Platform vs. Performance
> I don't see anything in there that is relevant to the original posting. The tables headed "Speed difference between different SQL servers (times in seconds)" The top row of each table shows times for the same operation on Linux and Windows, showing that for both operations tested, Linux achieves 50% better throughput (takes 2/3 of the time). Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Platform vs. Performance
I don't see anything in there that is relevant to the original posting. Andy > -Original Message- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs > Sent: 18 September 2003 14:04 > To: [EMAIL PROTECTED] > Subject: Re: Platform vs. Performance > > > In article <[EMAIL PROTECTED]>, > "Andy Eastham" <[EMAIL PROTECTED]> writes: > > > Jeremy, > > I don't think there's a huge difference in WinTel performance and Linux, > > given the same hardware. > > The following URL tells you that there's a big difference between > Windoze and Linux: > > http://www.mysql.com/information/presentations/presentation-oscon2 000-2719/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Platform vs. Performance
> > Pros? Cons? I know the windows box would need a good reboot now > > and then and what is the performance hit on a WinTel 98/XP Pro > > platform vs Linux? Looking at a 40K record database with maybe > > 3 users at a time running 5-10 Large (length of the select > > statment is over 500 characters normally) queries at a time. I would not bother with '98 if XP is an option. If it is a windows shop then go with that, but if it is OS agnostic, and you or ANOTHER will be admining it, then my choice would be a *nix variant as it is less likely to have some nasty RPC bug and easier to admin remotely. This assume good *nix knowledge. Apart from that the performance will be roughly the same, I say roughly as you do not need to run a truck load of stuff on a DB server in *nix land, so there is more resource available for apps, but I doubt your app will stress a modern machine that much. There cat amongst the pigeons. Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Platform vs. Performance
Jeremy, I don't think there's a huge difference in WinTel performance and Linux, given the same hardware. Anyway, your application is so lightweight, it's not really going matter very much. Ease of administration for you and your client will be far more important. Andy > -Original Message- > From: Jeremy Proffitt [mailto:[EMAIL PROTECTED] > Sent: 17 September 2003 23:18 > To: [EMAIL PROTECTED] > Subject: Platform vs. Performance > > > We are currently using an access database going through an odbc > connection in vb.net for our application (which is still in > development). The plan was to use MySQL in the end and we are > needing to cross that bridge. > > I was wondering the Performance differences between running MySQL > on a Linux box vs. a WinTel Platform. The WinTel looks inviting > because we can put in an easy to administrate Windows 98 or XP > Pro box in the corner of our clients office. I would rather not > tackle Linux as I would need file sharing and the ability to > backup and remote administration. > > Pros? Cons? I know the windows box would need a good reboot now > and then and what is the performance hit on a WinTel 98/XP Pro > platform vs Linux? Looking at a 40K record database with maybe > 3 users at a time running 5-10 Large (length of the select > statment is over 500 characters normally) queries at a time. > > Any help is greatly appriciated! > > Thanks! > > Jeremy Proffitt > Computer Programmer, Pearson Appraisal Services, Inc. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Platform vs. Performance
We are currently using an access database going through an odbc connection in vb.net for our application (which is still in development). The plan was to use MySQL in the end and we are needing to cross that bridge. I was wondering the Performance differences between running MySQL on a Linux box vs. a WinTel Platform. The WinTel looks inviting because we can put in an easy to administrate Windows 98 or XP Pro box in the corner of our clients office. I would rather not tackle Linux as I would need file sharing and the ability to backup and remote administration. Pros? Cons? I know the windows box would need a good reboot now and then and what is the performance hit on a WinTel 98/XP Pro platform vs Linux? Looking at a 40K record database with maybe 3 users at a time running 5-10 Large (length of the select statment is over 500 characters normally) queries at a time. Any help is greatly appriciated! Thanks! Jeremy Proffitt Computer Programmer, Pearson Appraisal Services, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]