+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Best engine for save many records (/showthread.php?tid=73763)
Best engine for save many records - omid_student - 06-02-2019
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
RE: Best engine for save many records - php_rocs - 06-02-2019
@omid_student,
I don't think you can go wrong with either one. If I had to pick, I would go with MySQL.
RE: Best engine for save many records - InsiteFX - 06-03-2019
Just make sure you add a index to your search fields.
RE: Best engine for save many records - omid_student - 06-03-2019
(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
RE: Best engine for save many records - omid_student - 06-03-2019
(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?
RE: Best engine for save many records - php_rocs - 06-03-2019
@omid_student,
Are you asking which one (MySQL or MongoDB) is better to use?
RE: Best engine for save many records - omid_student - 06-03-2019
(06-03-2019, 06:17 AM)php_rocs Wrote: @omid_student,
Are you asking which one (MySQL or MongoDB) is better to use?
Yes
RE: Best engine for save many records - InsiteFX - 06-03-2019
You may need to raise the number of open connections in my.ini
I think php.ini also has a value for it.
RE: Best engine for save many records - hc-innov - 06-04-2019
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.persistent-connections.php