On 4/24/2012 6:01 PM, Stephen Russell wrote: > I don't think either will matter unless you have one MEGA table that > is 5 - 10 mill rows.
Does the row count really play a part? I always thought it was the total size of the table moreso than how many rows it has? Hmmm... > > 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. Let's say I've properly indexed it for the sake of this discussion. :-) > > 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. I'm using what the company is offering. <g> We're a Windows shop. It's just another person and myself and we each have our own databases to run against, so buying a new server for this once-a-year operation doesn't sound like the right move; rather, utilizing these spare laptops we have in our arsenal sounds like an easier, cheaper, faster approach. > > 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. See indexing comment above. <g> > > 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. I'm not really sure honestly that my MariaDB is logging all kinds of stuff...I think I turned that option off. ??? I have no need for the logs in this case. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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/[email protected] ** 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.
