Hello Backendless ,
As Far As I have Experimented and Inferenced upon the Results , I have noticed that Backendless is not indexing custom data tables . For verifying this experiment , I replicated the Data Table of User as “Dummyuser” with exactly the Same Data base Schema : and Applied the Indexed Constraint to Every database Tables. And When I experimented with Searching on the “Dummyuser” , it’s taking almost twice the time it had taken over searching the “User Table” . I am wondering if the Indexing is not working as I have read in the discussions or somewhrre that the “User” Table is indexed automatically .
I hope if you guys could reflect on it .
Regards,
Pujan
Hi Pujan,
Each table is indexed by objectId.
Following articles could be useful for you:
Regards,
Denys
@Denys Konakhevych
Okay , I read the articles . I understood that we should index the table by objectId . By Indexing ObjectId , as per my above question , Why is Dummy Table , with same database Schema taking way too much time to load than the User Table itself.
Regards,
Pujan Paudel
Did you replicated User table by import\export operations?
@Denys
No I didn’t do any Sorts of Import\ export Operations. I just made a Plain Data table ( I replicated User Table just for test Purposes only and nothing more )
Regards
Could you please provide your appId?
Regards
Hello @Denys Konakhevych
My App ID is : F665896D-EBEB-F072-FFF6-839E12F64800
Can you Please Check what’s stopping me from getting Faster Even after Indexing the LightWeightTestUsers Table.
P.S I will be indexing the Objectid of the Other Tables too. So , I’d be glad if you people can find out what’s going wrong , or If I have done anything wrong from my part 
How are you going to index objectId? I can only see single constraint - not null constraint for “post_title” column of table “NewPost”
Hello Denys,
I did my Experiment on “LightWeightTestUsers” Table where I have indexed the other columns in the Constraint
Hello Pujan,
This indexes are useful when you have big amount of records in table and have many search queries by ‘userName’ or ‘profilePictureUrl’ columns. But the cost of it is that each insert will cause rebuilding of each of this indexes. Indexes should be used with great careful. There are some advices of using indexes: http://www.tutorialspoint.com/sql/sql-indexes.htm.
Regards,
Denys
Following gk could be useful for youhttp://www.gkindiaonline.com/
General Knowledge