Yii Framework Forum: What is the better table type to big table - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

What is the better table type to big table Rate Topic: -----

#1 User is offline   MagnusSolution 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 22
  • Joined: 13-August 12

Posted 26 July 2017 - 08:23 AM

Hello everyone.

I developer a BIG system OPEN SOURCE with Yii http://www.magnusbilling.com

In this system there is a big table that can have more than 3 millions, and about 3 or more new inserts per seconds.

Actually I use InnoDB, but is the better option?

Best regards
www.magnusbilling.com
0

#2 User is offline   alrazi 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,315
  • Joined: 08-August 12
  • Location:Durban, South Africa

Posted 26 July 2017 - 08:44 AM

3 million is not big InnoDb is one of the best open source engine out there, there are commercial engines e.g. percona XtraDB
0

#3 User is offline   alrazi 

  • Elite Member
  • PipPipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,315
  • Joined: 08-August 12
  • Location:Durban, South Africa

Posted 31 July 2017 - 12:47 AM

depending on the workload there are other options contact me if you would like to discuss this further.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users