Tuesday, 2 May 2017

Change Nodejs/Expressjs/Feathersjs user ID formula to sequential number

I am working on my first nodejs based project using Feathersjs as a backend and Vue as frontend. When I look in the database then the user ID is a character string looking something like this: "IXS1rCoGogkdOOss".

This seems like it will use more storage space than needed, when a integer user id would suffice.

Can the storage space requirement be reduced somehow?

Perhaps by having the user ID stored as an integer in the database instead of a text string?

I have tried to look through the code but I can not find where the user ID assignment occurs. I am new to both javascipt and node.js and I just can't get my head around this. Searching this site and googling also turned up nothing.

And the reason why it seems like a good idea to reduce the storage size of the user ID is that this will be a multi tenant SaaS with less than 10k users but close to a billion rows containing the user ID.

Thanks for the help!



via Matty

No comments:

Post a Comment