Performance Codeigniter, + 2 million records.

Performance Codeigniter, + 2 million records.

php_rocs
Administrator
Posts: 1,399
Threads: 86
Joined: Jun 2016
Reputation: 72

#10

08-13-2021, 07:18 AM

@[email protected]
What version of CI are you using? What version of MySQL are you using?

Also, what fields are indexed in the listeners table?

The EXPLAIN is telling you that you are actually going through 14283406 rows of data to find your solution (That's really bad). It is basically telling you that you need indexes.

Messages In This Thread

Performance Codeigniter, + 2 million records. - by [email protected] - 08-02-2021, 07:59 AM

RE: Performance Codeigniter, + 2 million records. - by php_rocs - 08-02-2021, 03:46 PM

RE: Performance Codeigniter, + 2 million records. - by [email protected] - 08-11-2021, 04:04 PM

RE: Performance Codeigniter, + 2 million records. - by albertleao - 08-02-2021, 04:21 PM

RE: Performance Codeigniter, + 2 million records. - by [email protected] - 08-10-2021, 01:13 PM

RE: Performance Codeigniter, + 2 million records. - by donpwinston - 08-12-2021, 02:25 AM

RE: Performance Codeigniter, + 2 million records. - by InsiteFX - 08-12-2021, 03:08 AM

RE: Performance Codeigniter, + 2 million records. - by [email protected] - 08-12-2021, 06:51 AM

RE: Performance Codeigniter, + 2 million records. - by InsiteFX - 08-13-2021, 03:28 AM

RE: Performance Codeigniter, + 2 million records. - by [email protected] - 08-13-2021, 04:48 PM

RE: Performance Codeigniter, + 2 million records. - by php_rocs - 08-13-2021, 07:18 AM

RE: Performance Codeigniter, + 2 million records. - by [email protected] - 08-13-2021, 04:51 PM

RE: Performance Codeigniter, + 2 million records. - by php_rocs - 08-14-2021, 09:07 AM

RE: Performance Codeigniter, + 2 million records. - by [email protected] - 08-19-2021, 11:14 AM

RE: Performance Codeigniter, + 2 million records. - by InsiteFX - 08-20-2021, 12:35 AM