->row() without limit() causes high load

->row() without limit() causes high load

khashabawy
Junior Member
Posts: 24
Threads: 15
Joined: Oct 2014
Reputation: 0

05-18-2018, 03:40 AM

(05-17-2018, 08:55 PM)Paradinight Wrote:
(05-17-2018, 12:32 PM)khashabawy Wrote:
(05-16-2018, 03:19 AM)InsiteFX Wrote: Of course it will it's pulling in all the records matching your search.

It is supposed that results() does that but row() by default limits to 1 !!

1. row return 1, but it does not limit the results from the database.
2. Add an index to the field. An index speed up the search.

Does not this considered a bug ? why does not row() limit to 1 row() ?

Messages In This Thread

->row() without limit() causes high load - by khashabawy - 05-16-2018, 01:07 AM

RE: ->row() without limit() causes high load - by InsiteFX - 05-16-2018, 03:19 AM

RE: ->row() without limit() causes high load - by khashabawy - 05-17-2018, 12:32 PM

RE: ->row() without limit() causes high load - by Paradinight - 05-17-2018, 08:55 PM

RE: ->row() without limit() causes high load - by khashabawy - 05-18-2018, 03:40 AM

RE: ->row() without limit() causes high load - by dave friend - 05-21-2018, 09:47 AM

RE: ->row() without limit() causes high load - by mihiran - 05-17-2018, 05:57 PM

RE: ->row() without limit() causes high load - by zjonsnowz - 05-18-2018, 08:15 AM