CodeIgniter Forums - Search Results

Search Results

Thread: Performance Codeigniter, + 2 million records.
Post: RE: Performance Codeigniter, + 2 million records.

php_rocs Wrote: (08-14-2021, 09:07 AM) -- @"[email protected]" , Wow!! you only have one index on this table and the field that is indexed isn't even used in your query. Here is a good read on in...

Thread: Performance Codeigniter, + 2 million records.
Post: RE: Performance Codeigniter, + 2 million records.

php_rocs Wrote: (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? T...

Thread: Performance Codeigniter, + 2 million records.
Post: RE: Performance Codeigniter, + 2 million records.

InsiteFX Wrote: (08-13-2021, 03:28 AM) -- On you from, the * is very slow in queries. Try using a field name to search on. Good evening, the query with ( * ) I did only with EXPLAIN, when I do the...

Thread: Performance Codeigniter, + 2 million records.
Post: RE: Performance Codeigniter, + 2 million records.

InsiteFX Wrote: (08-12-2021, 03:08 AM) -- Run your query in phpMyAdmin and use the explain command to see if it will speed it up. Good morning, I put this query in phpMyAdmin: EXPLAIN SELECT *...

Thread: Performance Codeigniter, + 2 million records.
Post: RE: Performance Codeigniter, + 2 million records.

php_rocs Wrote: (08-02-2021, 03:46 PM) -- @"[email protected]" , My question to you would be have you done a database query analysis to make sure that your query/queries are efficient? - Good...

Thread: Performance Codeigniter, + 2 million records.
Post: RE: Performance Codeigniter, + 2 million records.

I put some columns as indexes inside MySQL to see if it improves, when I test without calculations or groupings inside the query it ends up being faster, today a table has more than 19 million records...

Thread: Performance Codeigniter, + 2 million records.
Post: Performance Codeigniter, + 2 million records.

Good morning people! I have a problem with Code requests, when it has less than 1 million records, it loads considerably fast, starting from that mark it takes a long time to request. A very imp...