jwcolby
jwcolby at colbyconsulting.com
Mon Sep 26 07:01:18 CDT 2011
Mark, > Only one comment here, I would not dream of messing around with mySQL on that box. At this point I would not either. My understanding is that they will play together but it would be purely play (benchmarks), no business reason to do so. John W. Colby www.ColbyConsulting.com On 9/26/2011 5:51 AM, Mark Breen wrote: > Hi John, > > Only one comment here, I would not dream of messing around with mySQL on > that box. > > Mark > > > On 20 September 2011 12:49, jwcolby<jwcolby at colbyconsulting.com> wrote: > >> Mark, >> >> >>> Finally, I would adore to hear some results comparing your db between MS >> SQL and mySQL >> >> I don't know how to do this. I am a little hesitant to install MySQL on my >> big server where I could do an A/B comparison with the big SQL database. I >> can install SQL server on the VMs with MySQL for testing but then you are >> restricted to one core, x32 OS etc. >> >> Maybe some day, when I have tons of MySQL experience and am confident I >> will not hose my server I will go ahead and install MySQL on that machine. >> >> >> John W. Colby >> www.ColbyConsulting.com >> >> On 9/19/2011 6:57 PM, Mark Breen wrote: >> >>> Hi John, >>> >>> Ok, sorry, when you mentioned Access I assumed that the db's were not too >>> big. >>> >>> Can I throw a few things out, just in case they are useful for you? >>> >>> 1) I have been playing with Ubuntu recently and it is fun. >>> 2) I successfully installed mySQL on Ubuntu over the weekend - I have more >>> testing to do but for your client, that's all free and it is good >>> software. >>> 3) Once you get your mySql server up, you can do all the rest of your work >>> in MS world, just use mySQL as your data store. No reason not to use >>> VS2010 >>> as your FE and mySQL as your BE. >>> >>> Do not be afraid of Ubuntu, it is not that difficult and weirdly, it is >>> satisfying in a way that Win 98, Millennium , Vista, Office 97, VS 2003 >>> (need I go on) can never be. >>> >>> Finally, I would adore to hear some results comparing your db between MS >>> SQL >>> and mySQL >>> >>> Mark >>> >>> >>> >>> On 19 September 2011 01:00, jwcolby<jwcolby@**colbyconsulting.com<jwcolby at colbyconsulting.com>> >>> wrote: >>> >>> Mark, >>>> >>>> The reasons are exactly what Jim mentioned. The client currently has >>>> around 5 gigs of data, or at least their mdb containers are around that >>>> size. >>>> >>>> The free SQL Server express has the following limitations: >>>> >>>> 1) 10 gb file size >>>> 2) 1 core maximum >>>> 3) 1 gig ram maximum >>>> >>>> And the client has: >>>> >>>> 4) Serious money constraints today. >>>> >>>> SQL Server Express 2008 is just fine for a small database with a hand >>>> full >>>> of users but this is a fairly serious call center app, with 25 users in >>>> the >>>> database all the time. It just feels like a single core and a single gig >>>> is >>>> starting with serious limitations. >>>> >>>> He was "written a check" for $2K for purchasing a new server to take him >>>> into the future. I proposed $2400 for a "roll your own" 8 core AMD 6128 >>>> and >>>> 16 gigs of ram, a modern 8 port Areca raid controller and 3X 120g hard >>>> drives. He went back to the controller and got $3K. With that he added >>>> 5X >>>> 1 tb drives to build out some real storage for the company. They have >>>> always had old ebay Dell servers with too little memory and too little >>>> storage. Always trying to shuffle things around to free up room. >>>> >>>> We are actually looking at starting with Windows XP X64 as the OS on this >>>> (otherwise) entirely modern system. If it works that gets rid of the "$X >>>> per seat" for something like Windows 2008. If we can use MySQL on that >>>> with >>>> let's say 6 cores and 12 gigs of ram and a 60 gig SSD partition for the >>>> database files he could have a fairly serious system for his company >>>> size. >>>> >>>> Windows 2008 and SQL Server 2008 together were going to cost him around >>>> $10K just for those two things. While we may go there next year or the >>>> year >>>> after, I want to get him moving now. We have been stuck in neutral and >>>> rolling backwards for too long. >>>> >>>> >>>> John W. Colby >>>> www.ColbyConsulting.com >>>> >>>> On 9/18/2011 11:24 AM, Mark Breen wrote: >>>> >>>> Hello Jim / Arthur >>>>> >>>>> Thanks for that analysis, quite accurate. >>>>> >>>>> Mr Colby, just a question, why are you not advising your client to use >>>>> the >>>>> free MS SQL express R2. I use it all the time and PowerDNN use it on >>>>> all >>>>> there servers that host 100,000 DNN installations. All free db's. That >>>>> is >>>>> not to be sniffed it. And there are loads of tools to help with the >>>>> enterprise tools that Express does not ship with. (Note: the free >>>>> version >>>>> does give you SSMS) >>>>> >>>>> Mark >>>>> >>>>> ______________________________****_________________ >>>> dba-SQLServer mailing list >>>> dba-SQLServer@**databaseadviso**rs.com<http://databaseadvisors.com>< >>>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>>>> >>>> http://databaseadvisors.com/****mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver> >>>> **<http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>>> **> >>>> http://www.databaseadvisors.****com<http://www.**databaseadvisors.com<http://www.databaseadvisors.com> >>>>> >>>> >>>> >>>> ______________________________**_________________ >>> dba-SQLServer mailing list >>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>> http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >>> >>> >>> ______________________________**_________________ >> dba-SQLServer mailing list >> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >