On Tue, Apr 24, 2012 at 4: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 >
And what is the problem you're trying to solve? Are your data scripts adding new data (INSERT/UPDATE) or querying (SELECT) and what's the problem? I'd guess slow response, but... there's that saying about ASSuME.... Which data storage engine are you using? Why? Does the database have to be on a laptop? The first, cheapest database performance optimization is "spindles, spindles and more spindles:" OS on its own disk, data on one, index on another, logs on a third. Disk I/O is orders of magnitude slower than CPU or memory performance and is cheap, cheap, cheap to solve... on a box, not a laptop. Throwing RAM at the problem can't hurt, with dirt-cheap RAM prices. But if it's write I/O you're optimizing, you might not see much of a performance increase unless you tweak cache settings. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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/CACW6n4v_XJZxjKo3qKW9dY2MNytaPJizxN8Y=tawn6zxatu...@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.
