• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Best engine for save many records

#1
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
Reply

#2
@omid_student,

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

#3
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 )
Reply

#4
(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
Reply

#5
(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?
Reply

#6
@omid_student,

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

#7
(06-03-2019, 06:17 AM)php_rocs Wrote: @omid_student,

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

Yes
Reply

#8
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 )
Reply

#9
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
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.