Best engine for save many records

Hi
I need save many records in table
This records are locations
lat,lon,speed,time
lat,lon,speed,time

over 10 million

User need get location according of date special for 2019-12-24

Is it good Mysql for this project?
Or MongoDB is good?

I use Partition and Index on table and also cache query

Thanks

@omid_student,

I don't think you can go wrong with either one. If I had to pick, I would go with MySQL.

Just make sure you add a index to your search fields.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

@omid_student,

I don't think you can go wrong with either one.  If I had to pick, I would go with MySQL.

I got confused

Just make sure you add a index to your search fields.

I added Index
Recently,mysql show error too many connection or restart transaction
Why?

@omid_student,

Are you asking which one (MySQL or MongoDB) is better to use?

@omid_student,

Are you asking which one (MySQL or MongoDB) is better to use?

Yes

You may need to raise the number of open connections in my.ini

I think php.ini also has a value for it.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Hi,

may be trying to disable persistent connection can help you.
Change in your php.ini:
mysql.allow_persistent=0
or mysqli.allow_persitent=0

In codeigniter : config/database:
'pconnect' => false

see the warning: https://www.php.net/manual/en/features.p...ctions.php