Welcome Guest, Not a member yet? Register   Sign In
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...
10,536 Views
14 Replies
08-19-2021, 11:14 AM
[email protected]
    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...
10,536 Views
14 Replies
08-13-2021, 04:51 PM
[email protected]
    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...
10,536 Views
14 Replies
08-13-2021, 04:48 PM
[email protected]
    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 *...
10,536 Views
14 Replies
08-12-2021, 06:51 AM
[email protected]
    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...
10,536 Views
14 Replies
08-11-2021, 04:04 PM
[email protected]
    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...
10,536 Views
14 Replies
08-10-2021, 01:13 PM
[email protected]
    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...
10,536 Views
14 Replies
08-02-2021, 07:59 AM
[email protected]

Theme © iAndrew 2016 - Forum software by © MyBB