Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
C
C
crwbr2015-11-22 20:36:35
PHP
crwbr, 2015-11-22 20:36:35

How to quickly fetch a million records from MySQL?

How to get a million records out of MySQL quickly and with pagination of 20 records each?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
I
Igor, 2015-11-22
@unitby

take out where?
you need to use either limit in the request, or dataTable on the page, or google paginator

Similar questions
W
WebforSelf2021-03-23 23:45:26
How to start server after centos 7 backup, vestacp? 3Reply
R
Ravshan Enikeev2018-03-19 22:07:01
PHP: how to write a script to rename crooked filenames? 3Reply
D
DjimiDjimi2018-03-20 08:10:03
Why is the proxy not reset in the CURL PHP class? 1Reply
D
dk-web2015-11-11 21:51:24
Is it possible to generate a link to google maps? 1Reply
D
Denis2021-07-14 12:47:19
Can't figure out how to write a php function? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question