Forum BigDB Count indexes per table

Discussion and help relating to the PlayerIO database solution, BigDB.

Count indexes per table

Postby Bestlis » September 15th, 2016, 2:40 pm

Hello there!
I try to create indexes in any table and problem with count.
I can not create more tha 4 indexes.
Is there any limitaion?
If I choose not free plan, will count indexes increase?

Thanks!
Bestlis
Paid Member
 
Posts: 15
Joined: August 6th, 2014, 3:00 pm

Re: Count indexes per table

Postby ChristianD » September 15th, 2016, 9:22 pm

Hi Bestlis,

No, you can't create more than 4 indexes per BigDB table, and the limit is the same for all premium plans as well.

What are you trying to do that would require more indexes than that?
Christian
ChristianD
.IO
 
Posts: 63
Joined: May 13th, 2016, 4:44 am

Re: Count indexes per table

Postby Bestlis » September 19th, 2016, 7:20 am

So, there is no solution to increase index's count?
Bestlis
Paid Member
 
Posts: 15
Joined: August 6th, 2014, 3:00 pm

Re: Count indexes per table

Postby ChristianD » September 21st, 2016, 2:59 am

No, sorry.

If you describe the problem you are trying to solve, we might be able to help you find an alternative solution.
Christian
ChristianD
.IO
 
Posts: 63
Joined: May 13th, 2016, 4:44 am

Re: Count indexes per table

Postby Bestlis » September 21st, 2016, 7:52 am

I created 4 idexes, which I using for day, week, year and money raiting.
Are there any other ways to create ordered lists of objects?
Thanks.
Bestlis
Paid Member
 
Posts: 15
Joined: August 6th, 2014, 3:00 pm

Re: Count indexes per table

Postby ChristianD » September 21st, 2016, 3:38 pm

Can you re-use indexes for the different lists?

Another way is to separate the lists into different tables and write the score to all of them.
Christian
ChristianD
.IO
 
Posts: 63
Joined: May 13th, 2016, 4:44 am

Re: Count indexes per table

Postby Bestlis » September 22nd, 2016, 7:23 am

Thanks for reply.
I will try.
Bestlis
Paid Member
 
Posts: 15
Joined: August 6th, 2014, 3:00 pm

Re: Count indexes per table

Postby Zwick » September 26th, 2017, 8:50 pm

I have to admit that the limit of four indexes is really restrictive.
Why there is no chance to increase them?

For example I have playerObjects data with multiple values (XP, best time, best combo, best win streak, wins, losses) and there is no way how to sort them.... :|

Image
Zwick
 
Posts: 19
Joined: December 2nd, 2012, 3:35 pm

Re: Count indexes per table

Postby Henrik » September 27th, 2017, 4:08 am

Sorry, the hard limit on indexes is there for a good reason.

What you can do to work around it is to put the values you want to sort on in another BigDB table where you use the same key as in the PlayerObjects table (the connectuserid), and then you can put four new indexes on that, and do lookups, and get the connectuserids of the users that match your lookups.
Henrik
.IO
 
Posts: 1880
Joined: January 4th, 2010, 1:53 pm

Re: Count indexes per table

Postby Emalton » April 20th, 2021, 3:03 am

The Leaderboards feature should help with this use case, but it still would be good to have on paid plans!
Emalton
 
Posts: 86
Joined: June 28th, 2013, 3:49 am


Return to BigDB



cron