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

i noticed that selecting row() without putting limit() in the active record is causing high load !!

anyone noticed that ?

Of course it will it's pulling in all the records matching your search.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

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 !!

Use Prepared Statements with PDO

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.

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() ?

There is a reason for that.
Read the docs https://www.codeigniter.com/user_guide/d...sults.html (Result Rows)

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

There is a difference between making a query and obtaining a results set from a query.