I couldn’t find an answer to this in the Frappe Framework document.
I assume checking the field will result in data getting indexed in the db.
@Muzzy Indexing a field (or column) in a database table means creating a data structure that improves the speed of data retrieval operations for that field. An index works like a lookup table that allows the database to locate data quickly without scanning every row in the table.
1 Like
Thank you. I am aware of what you stated. My question us does the check box leads to db index of the field or it has some other purpose?
It is exactly that, db index.
1 Like
so why not put index in all as compulsory?
Wont that make the system better.
I am sorry if this is a very bad question
Perfectly valid question to ask. The reason is that indexes take up space, and that space is better used for other things. They also add compute time for things like insertions and deletions. Generally, you don’t need to look up a table against every field - so you optimize for space and compute time, and only index fields that are used quite a lot for filtering.
Reference: sql - MySQL - why not index every field? - Stack Overflow
3 Likes
Awesome Explanation.
Thanks it helped alot!!! 