Yii Framework Forum: Choose Database Engine - Yii Framework Forum

Jump to content

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

Choose Database Engine

#1 User is offline   mmta41 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 12
  • Joined: 26-September 13

Posted 12 June 2018 - 02:26 PM

Hi,
We are starting new project in scale of 3,000,000 of users and 60,000,000 records yearly.
there will be complex queries with join on tables to generate reports and/or check users history and limits while creating new record, we are currently on Yii2 and MySQL database,
but there is concern about MySQL performance and we have no clue how much MySQL is reliable in this scale of data.
We hope some experienced guy can give us advice about this.
0

#2 User is offline   jimgwhit2 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 62
  • Joined: 27-September 17
  • Location:U.S.A.

Posted 12 June 2018 - 08:37 PM

Have you seen: https://dev.mysql.co.../en/limits.html

Normally for a large application I would use servlets, ejb's, and jsp.
If you are concerned about it use SAP or MaxDB. But mysql isn't the problem,
php and huge database and traffic don't go together well.

You have to ask yourself, what setup does

* Fedex
* CH Robinson
* JB Hunt
* Sams Walmart logistics
* etc

use? Then decide.

And why github markdown does not work here is beyond me.

This post has been edited by jimgwhit2: 12 June 2018 - 08:39 PM

0

#3 User is offline   mmta41 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 12
  • Joined: 26-September 13

Posted 14 June 2018 - 01:40 AM

View Postjimgwhit2, on 12 June 2018 - 08:37 PM, said:

Thanks for your reply.
Unfortunately none of your suggested solution is not available for us, since we live in Iran and unfair US goverment sanctions prevent American companies to sell service to Iran event start-up companies like us.
0

#4 User is offline   Knight Yoshi 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 63
  • Joined: 13-March 17

Posted 17 June 2018 - 01:09 AM

MySQL 8 has better performance and support for 100M rows or around 100MB/table and many optimizations.

Here's a slide presentation Gabriela Ferrara put together for her talk at a conference she's going to
https://www.slidesha...?from_m_app=ios
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