3 billions records in phpmyadmin

Codes here !

Moderators: egami, macek, gesf

Post Reply
gopalkumar315
New php-forum User
New php-forum User
Posts: 5
Joined: Wed Feb 14, 2018 8:05 pm

Wed Feb 14, 2018 8:23 pm

I have above 3 billions of records actually it is my client work. I am totally confuse how to manage it, speed up the query. It am using laravel as api.
Thanks

chorn
php-forum Fan User
php-forum Fan User
Posts: 564
Joined: Fri Apr 01, 2016 2:18 am

Thu Feb 15, 2018 12:24 am

use the index luke. (and try explain analyze)

gopalkumar315
New php-forum User
New php-forum User
Posts: 5
Joined: Wed Feb 14, 2018 8:05 pm

Thu Feb 15, 2018 10:47 am

I have heard about the index but i don't think so index will work on such big table with joins. i am using phpmyadmin. Can you explain me what is luke in your statement.
Thanks

chorn
php-forum Fan User
php-forum Fan User
Posts: 564
Joined: Fri Apr 01, 2016 2:18 am

Sun Feb 18, 2018 11:05 pm

why not? it may depend on the database type and engine, but indexes are especially for large data sets, they dont work very well on small tables. just search for "use the index luke".

gopalkumar315
New php-forum User
New php-forum User
Posts: 5
Joined: Wed Feb 14, 2018 8:05 pm

Mon Feb 19, 2018 1:18 pm

thanks

Post Reply