Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums CodeIgniter 4 CodeIgniter 4 Support softDelete and database indexing
softDelete and database indexing
  • Offline includebeer
    CodeIgniter Team
  • Posts: 1,018
    Threads: 18
    Joined: Oct 2014
    Reputation: 40
#3
08-21-2019, 04:09 PM

(08-21-2019, 02:03 PM)php_rocs Wrote: @MGatner,

There is no need to index that field. It's only purpose is to exclude the deleted records from queries that should only show non deleted records.

If it’s used in every request then it could be a good idea to index it. But it I think it will only improve performance if you have a lot of record. For a small table, it won’t make a difference.
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/
Reply


Messages In This Thread
softDelete and database indexing - by MGatner - 08-21-2019, 11:23 AM
RE: softDelete and database indexing - by includebeer - 08-21-2019, 04:09 PM
RE: softDelete and database indexing - by MGatner - 08-24-2019, 06:32 AM
RE: softDelete and database indexing - by MGatner - 08-25-2019, 03:56 AM
RE: softDelete and database indexing - by MGatner - 08-25-2019, 04:58 PM



Theme © iAndrew 2016 - Forum software by © MyBB