1. François Van Lerberghe
  2. Valentina Database ADK
  3. Dienstag, Januar 12 2016, 11:01 AM
  4.  Abonnieren via E-Mail
Using VStudio, I see several indexed fields (a few, not all) have a property named "FORCE_INDEXED" with value = 1.
What is the meaning/use of this property ?
Why some indexed fields have it but not other ?
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Francois,

* Valentina DB can self make some field to be indexed. When user did not asked.

* Such field is marked as FORCE_INDEXED.

* This is reflected in the SHOW INDEXES result. Only here.
Valentina Studio show that also.

* I have checked sources, for now only SORTING on field, affects this.
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
Ok. Thus I don't worry about this property. And I can delete it if I want.
Thank you.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
On the other hand this is sign that this field should be indexed.

If field get this AFTER work of your app then with sure.

Only if this was made from e.g. vstudio by incident, then not required
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
Ok. But I thought, as I'm not a database expert, that I must set an index only when it's a sort/search frequently done. Sometimes the user can do a custom sort or search that is occasional. Do you say that I must set an index in this case ?
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Only if often ...

But as you have see even user once do it, Valentina set it as indexed.
May be then you may want remove that flag.

So do not ignore it so easy.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories