jwcolby
jwcolby at colbyconsulting.com
Fri Jun 29 17:26:23 CDT 2007
Yea I hear you. My issue is that in the 32 bit (windows) world, you only get 2gb assigned to the application. When you are trying to join a long (8 byte) from 65 million records with a long on 50 million records... You can use up a fair portion of your memory just on getting the join data into memory, never mind any other data. Not that I have a clue how SQL Server actually implements a join but still, you get my point here. I can afford (and my machines can handle) 8 gbytes but Windows 32 simply doesn't use it unless you step up to the advanced versions of Windows and then you start bleeding through the nose in licensing fees. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, June 29, 2007 5:52 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] 64 bit MYSql on 64 bit linux Hi John: I have been working with a 64bit version of Oracle but it was a nightmare to install as the hardware and the OS did not like each other and though I think it now has been changing, the drivers were/are still only 32bit and not very compatible. I experienced issues with sound, LAN connections, video displays and even printers. There were no obvious performance improvements over a 32bit DB version, on the same 64bit platform but I was only working with files of 100,000 records and less and not 10 of millions. The latest version of Linux/Vista/Server2003 are supposed have resolved these issues but I will be taking the wait and see approach before I make the next foray in the world of the 64bit. Jim -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, June 29, 2007 1:45 PM To: 'Access Developers discussion and problem solving'; 'Discussion of Hardware and Software issues'; dba-sqlserver at databaseadvisors.com Subject: [dba-Tech] 64 bit MYSql on 64 bit linux Is anyone using 64 bit database / OS software? My databases are so large that having 2 mb memory constraints are killing me (gut feeling here). But once I start looking at x64 versions of Windows Server and in particular x64 versions of SQL Server the prices skyrocket. I will be paying more for the licenses for those two things (for EACH processor chip) than I will for the entire machine hardware, and it is pretty heavy duty hardware. Thus I need to at least examine Linux / MySQL assuming that I can get 64 bit versions. John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com