Search found 76 matches

Search found 76 matches

Re: FYI: Upcoming Changes in 1.5.0

Also, I think you shouldn't underestimate consequences of this kind of issues. From a shop, you can order 1 item, but you can also order 50 or 100 items. A stock difference of 50 or 100 items is a huge difference. I should pay somebody to recount goods, I waste money, I waste time and time is money....

Jump to post
  • Mon Jan 03, 2011 5:06 pm
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

Well, I think the opposite :) If I lose some forum messages... that's not a big issue... but for a shop, reliability is critical because money is directly involved.
For that matter, also note that InnoDB is now the default engine for the newer versions of MySQL.

Jump to post
  • Mon Jan 03, 2011 4:18 pm
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

But yes it is true... it won't be happening anytime soon and still .. even with a lot of customers.. it is mostly read only. Only when an order is actually placed is there any real writing done to the DB, and any improvement there can be hidden by payment gateway delay.. so I can't see innodb being...

Jump to post
  • Mon Jan 03, 2011 1:53 pm
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

But weighing the pros and cons there is more likely that performance on a daily basis is more important than the 1 in 17million chance of a system failure right at a particular moment between updates. Well, InnoDB isn't that slow. It could be a bit slower but it's not really noticeable unless it's ...

Jump to post
  • Mon Jan 03, 2011 6:05 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

Yea I get it.. it lets you group multiple events into a single "atomic" event. But read vs write seems to be a bigger performance hit and for shopping carts I think performance is a bit more key than potential for errors. Well, I don't have a deep knowledge of OpenCart code, but in my mind I'd be w...

Jump to post
  • Mon Jan 03, 2011 5:24 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

There are sometimes very valid reasons for using database transactions to rollback before commital in the event of system failure. Except for maybe on the 'merchant service side', I would not intuitively apply them to a shopping cart though. They can cause more problems than they solve and are no s...

Jump to post
  • Mon Jan 03, 2011 5:03 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

SapporoGuy wrote: Is PDO really crap? (serious question)

I agree that it would be a nightmare since the entire cart would have to be re-done.
PDO would be the way to go, but it would require a major overhaul.

Jump to post
  • Mon Jan 03, 2011 4:43 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

Qphoria wrote:opencart does use both of those
What?

E.G.

SELECT COUNT(*) FROM table WHERE value=1 <--- OK

SELECT COUNT(*) FROM table <--- Very slow on InnoDB, COUNT(*) without WHERE clause

Jump to post
  • Mon Jan 03, 2011 3:53 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

What do you need to change to make the current sql queries support Inno DB? Basically nothing, but avoid things like COUNT(*) queries without WHERE clause, because they are slow on InnoDB (I don't know if OpenCart uses them). Also, you have to change something if you want to take advantage of thing...

Jump to post
  • Mon Jan 03, 2011 3:41 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

SapporoGuy wrote:@ once again
I don't know many hosting services that support inno db for mysql and to add to the fun.
Every hosting service that I've used in the last 6 years allows for InnoDB tables.
However, you can easily check if InnoDB is available.

Jump to post
  • Mon Jan 03, 2011 3:07 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

SapporoGuy wrote:Postgres can do that, but many people have only access to mysql on hosted servers.
Yes, but OpenCart uses MySQL, so adding InnoDB support (to use transactions) would be easier than adding PostgreSQL support.

Jump to post
  • Mon Jan 03, 2011 2:43 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

Qphoria wrote:then use magento
Yeah, I like OpenCart, it can be fine for small needs, but for serious business integrity is critical so I'll go for Magento. Thank you for your time.

Jump to post
  • Mon Jan 03, 2011 2:13 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

from the article as implemented by InnoDB opencart uses myism so no no transactions, and I'd hardly call it crititcal as practically no other ecommerce application does it either. Yeah, you need InnoDB for transactions with MySQL. This is critical because integrity is critical for ecommerce applica...

Jump to post
  • Mon Jan 03, 2011 12:32 am
  • Replies 81
  • Views 18596
Re: FYI: Upcoming Changes in 1.5.0

Does it use db transactions? This is critical.

Jump to post
  • Sat Jan 01, 2011 9:36 pm
  • Replies 70
  • Views 29437
Re: OpenCart v1.4.4

Are invoices fixed?

Jump to post
  • Wed Mar 17, 2010 7:41 pm
  • Replies 61
  • Views 28913
Re: OpenCart v1.4.3

In this version are invoices fixed for EU?

Jump to post
  • Sat Mar 13, 2010 6:13 am
  • Replies 39
  • Views 16476
Re: OpenCart v1.4.0

Hey Dan, I can post a module for payment via credit card charge? You can integrate it in new version? Best regards But in your countries there is a rechargeable credit card? In Italy yes Rechargeable credit cards are normal credit cards (but the owner can charge them when needed). If you mean payme...

Jump to post
  • Thu Jan 28, 2010 6:18 am
  • Replies 481
  • Views 149078
Re: Open Cart 1.4 Translations in 35 languages

Automatic translation (using Google, Babelfish etc.) is not a solution. It could be decent in order to have a very vague idea of the content but nothing else. I'm Italian, if you try to translate an Italian text to English using an automatic tool you'll have a 70% of trash.

Jump to post
  • Tue Jan 26, 2010 9:27 pm
  • Replies 27
  • Views 4259
Re: Invoicenumber(s) not correct according to EU law

This is an example of an Italian invoice http://www.gestionalev5.it/images/modello_fattura.jpg (just an example, layout may change)

Jump to post
  • Wed Jan 13, 2010 3:41 am
  • Replies 132
  • Views 39517

Search found 76 matches