Search found 76 matches

Search found 76 matches

Re: InnoDB vs MyISAM Discussion

well right there is where you're blowing it all out of proportion. Lets just say for grins you have a very slow server and a db transaction takes 6 seconds. We both know it should really be under 500 milliseconds, but we'll make the numbers easy. If you are doing 10 orders in 6 seconds then you are...

Jump to post
  • Sun Jun 05, 2011 3:54 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

Well I love opencart, but if you are doing 10 or 100 transactions at precisely the same second then you are not going to be using opencart. Maybe magento, but not likely if you are that big then you most likely have a system that was developed in house by your team of developers to be highly scalab...

Jump to post
  • Sun Jun 05, 2011 3:31 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

As I've already said, there's people who never make backups and - atm- never lost data. But it can happen... this is why people make backups. Maybe you never had issues with MyISAM, but issues can happen... and this is why atomicity, transactions etc. exist. You should prevent problems, when they h...

Jump to post
  • Sun Jun 05, 2011 1:32 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

That's not really how it was implied. "so probably he couldn't even install a cart or upload it to the server." To me you make it sound more like ignorant/stupid, not ignorant/ignore. Actually it's ignorant/ignore where "ignore" is "don't have knowledge about it". English is not my native language,...

Jump to post
  • Sun Jun 05, 2011 1:25 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

ekerazha have you ever actually lost any data because of myism? I've been doing ecommerce stores based on oscommerce and it's derivatives all of which use myism and opencart for over 7 years now and I've worked with several hundred stores and store owners and never once seen any data loss/corruptio...

Jump to post
  • Sun Jun 05, 2011 2:34 am
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

Again, you're putting words in my mouth. I'm not implying small to medium sized entrepreneurs are ignorant, but I would say that most of them are not web developers or IT professionals, nor should they be. As a small to medium sized business owner my focus should be on marketing my business and mak...

Jump to post
  • Sun Jun 05, 2011 1:59 am
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

And to the regular old small to medium size business owner, they have no idea how to do all those things you mention, nor do they have the money to throw at someone who does. Again, companies like ebay and amazon have the resources to optimize their sites, and they also have a greater need for Inno...

Jump to post
  • Sat Jun 04, 2011 11:34 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

That's the same thing that say people who never make backups... until something goes wrong. If they are "whole seconds" then it's not InnoDB, it's your wrong subjective impression. Perception is something that's different from person to person. You might think the slower page speed isn't all that s...

Jump to post
  • Sat Jun 04, 2011 10:58 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

I've never lost an order using MyISAM (knock on wood), but I have noticed the page loading speed was a lot slower than 2 milliseconds when using InnoDB. More like whole seconds. That's the same thing that say people who never make backups... until something goes wrong. If they are "whole seconds" t...

Jump to post
  • Sat Jun 04, 2011 10:42 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

When dealing with people and their short term patience, every millisecond counts. This is the reason why you should use InnoDB, if you have db inconsistencies and for example you lose orders, they won't be very patient... 2 milliseconds don't make any difference... a lost order (or similar) makes a...

Jump to post
  • Sat Jun 04, 2011 10:27 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

but a small to medium sized business running a web store, are they really gonna have a lot of write intensive activity? Would these sites benefit from having a faster write but a slower read? Likely, the speed difference would be negligible in both cases. But they would benefit of the improved reli...

Jump to post
  • Sat Jun 04, 2011 9:49 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

The "read" slowing down is mostly negligible, however the "write" speed is much better on InnoDB because MyISAM uses a table lock when writing. But above all, InnoDb is a magnitude more reliable.

Jump to post
  • Sat Jun 04, 2011 8:47 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

After Magento (which uses InnoDB), the new PrestaShop 1.4 added InnoDB support (I didn't check if they also take advantage of transactions).

Jump to post
  • Fri Jun 03, 2011 2:45 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

SapporoGuy wrote:1.) Why don't you recommend mixing?
Mainly because it's a waste of memory, as you run two engines instead of one.
3.) If you're doing all the files, you might as well make a change to db abstraction layer ...
If you ask me, PDO all the way. But this isn't the point here.

Jump to post
  • Fri Jan 14, 2011 5:33 pm
  • Replies 81
  • Views 18316
Re: InnoDB vs MyISAM Discussion

Does innodb need to be on the entire db or just some tables? You can have mixed tables but usually I don't recommend it. I think you should first try an InnoDB only approach, don't overrate the performance difference between it and MyISAM. Just avoid COUNT(*) without WHERE clause (like I said befor...

Jump to post
  • Tue Jan 04, 2011 1:25 am
  • Replies 81
  • Views 18316
Re: FYI: Upcoming Changes in 1.5.0

bajaber wrote: Blah blah blah
Cool story, bro

Jump to post
  • Tue Jan 04, 2011 12:42 am
  • Replies 81
  • Views 18316
Re: FYI: Upcoming Changes in 1.5.0

SapporoGuy wrote: Another question I have is, does PDO support this out of the box?
Of course, method beginTransaction() etc.

Jump to post
  • Tue Jan 04, 2011 12:06 am
  • Replies 81
  • Views 18316
Re: FYI: Upcoming Changes in 1.5.0

On the contrary, you are overselling the importance. 1. They were implemented for when they are needed, like banking systems, etc. Implementing them in every scenario is indeed for fun. 2. Great, so we will stick to what we have now. 3. I need sufficient proof that it is worth having a fire brigade...

Jump to post
  • Mon Jan 03, 2011 10:55 pm
  • Replies 81
  • Views 18316
Re: FYI: Upcoming Changes in 1.5.0

The possibility of a 1 in a million chance of the error happening does not justify the time and effort to redevelop the system You underestimate the issue. Every serious DBMS supports transactions, do you think they implemented transactions just for fun? Exactly. Keyword, IF. They don't cause any p...

Jump to post
  • Mon Jan 03, 2011 9:14 pm
  • Replies 81
  • Views 18316
Re: FYI: Upcoming Changes in 1.5.0

If stock levels are so critical to the extent that you make it sound, then you will never be satisfied. Transactions alone will not be enough. You have staff stealing from your store. Which is more important? Numbers not tallying on your system, and not even losing a cent (maybe just a few minutes)...

Jump to post
  • Mon Jan 03, 2011 7:18 pm
  • Replies 81
  • Views 18316

Search found 76 matches