On 04/10/2014 05:57 PM, Mike Copeland wrote: > Now, I've switched everything to client server with MariaDB as the > backend using the InnoDB engine. > > Is there any advantage to the 'old' approach?
Nope. Less data manipulation is better. Deleting records means you've got to do more maintenance to clean up the mess (like PACK, only the MySQL way). It's unnecessary churn. > Will there be any degradation as the single "All Inventory" file > grows, and grows, and grows? In a theoretical way, sure. But modern databases are tunable and should need only some minor tuning when you go from mega- to giga- to tera-bytes. > Is it 'dangerous' to put all the eggs in one basket? It's always dangerous to put all the eggs in one basket. But databases aren't eggs. I mean, look: they have a DROP command built in. You don't see that with eggs. You need to have backup functionality in place. But MariaDB is built for robust performance. > Am I creating a bottleneck for data access? Obviously the one table > will be used to query ALL inventory questions...is something in stock? > How many have been sold? How many are not sold? Since I'm using > InnoDB tables there shouldn't be any locking issues... > If there are benefits and disadvantages to each approach, is one the > preferred approach? Terabytes are easy enough to manage. If you've really got a lot (and I mean a lot a LOT) of data, you can start optimizing storage and performance with separate spindles for logs, data and indexes and SANs and RAID and so forth, but you're gonna need a lot of data for that. How big are we talking? -- Ted Roche & Associates, LLC http://www.tedroche.com/ _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
