Mongodb or Mysql |
Hi
I'm programming website with mysql that you can see here https://worldhotelcodes.com Please search 001h1001 You will see elapse 3 second for search I have 1 million and 200 thousand records in mysql Why it is slow? I was added index on main field Also i dont use like statment for where condition Only use WHERE code = '001h1001' Now i decide use mongodb Is it good solution or i try optimize mysql? Also i have other problem I need make search record on textchange input search that it will be slow if i search record for each character |
Messages In This Thread |
Mongodb or Mysql - by omid_student - 09-09-2019, 02:56 AM
RE: Mongodb or Mysql - by dave friend - 09-09-2019, 04:49 AM
RE: Mongodb or Mysql - by InsiteFX - 09-09-2019, 07:56 AM
RE: Mongodb or Mysql - by php_rocs - 09-09-2019, 08:40 AM
RE: Mongodb or Mysql - by omid_student - 09-09-2019, 01:02 PM
RE: Mongodb or Mysql - by InsiteFX - 09-09-2019, 01:48 PM
RE: Mongodb or Mysql - by omid_student - 09-10-2019, 11:57 AM
RE: Mongodb or Mysql - by php_rocs - 09-09-2019, 05:44 PM
|