CodeIgniter Forums

Full Version: Best engine for save many records
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
(06-02-2019, 09:08 PM)php_rocs Wrote: [ -> ]@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 Huh
(06-03-2019, 03:28 AM)InsiteFX Wrote: [ -> ]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?
(06-03-2019, 06:17 AM)php_rocs Wrote: [ -> ]@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.
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