David Westbrook
Posts: 0
Joined: Sat Sep 28, 2013 8:22 pm

Collection indexes

That isn't efficient since the Collection is being accessed twice instead of once. It's also not 100% effective. Between the time of reading and adding, a record could be added with the same key.

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Collection indexes

I have added this feature to our planning list.

Case
Posts: 0
Joined: Mon Mar 10, 2014 12:08 am

Collection indexes

Unique indexes would definitely help simplify some app logic and minimize queries for checking against records that must be unique. Any update as to where this falls on the planning list?

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Collection indexes

I'll check with our dev. team.

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Collection indexes

We are planning to add this in early summer.

Jesper Simonsen
Posts: 0
Joined: Sat Sep 28, 2013 8:37 am

Collection indexes

I would also like compound uniqe indexes because without these indexes we cannot be sure if another user is storing the Exact same values in another
row almost simultaniously. To avoid this Logic on app or in servercode cannot prevent this because from the moment you have confirmed that this record does not exist another user can save the same record just before you are saving the same record.

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Collection indexes

Hi Jesper,

This will be added in the end of July.

Return to “Issues”