On Tue, Apr 24, 2012 at 3:55 PM, MB Software Solutions, LLC <[email protected]> wrote: > Scenario: > - running lots of data scripts on MariaDB database that's several gigs > large on local laptop > - putting the maximum amount of memory (8 GB) on the laptop > - current OS is Windows XP, but I understand from Dell support tech > that I must use Windows 7 (or Vista) to take full advantage of extra > memory beyond 3.5 GB > > > Am I right in thinking that I must run the 64-bit version of MariaDB to > take full advantage of the memory beyond 3.5 GB on a Windows 7 machine? > I don't want to get all this memory and then handcuff myself because > I'm either using the 32-bit version of MariaDB and/or Windows XP. ----------------------
I don't think either will matter unless you have one MEGA table that is 5 - 10 mill rows. The db engine does the work for you and depending on how well your index schema is compared to the queries you are running is where the initial problem lies. Now having Win7 64 bit is the best you can get today. Why the heck are you putting this on a WIN device anyway? Kind of like bringing the NASCAR vehicle to a dirt track. Putting a lot of ram on any db that is getting hit is always a good thing but more often it is the index the db engine chooses to use that SLOWS things down. Thus 8 gig or 12,16 gig there is no performance boost. Last point is that teh db is spinning on the only disk that the laptop has so it is not set for any performance at all. Your logs will be writing to the same spindle and that is not good for performance either. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyj6ozde06apqc2hu6pg25gayghwtukzw8jwk2bzdpi...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
