Hi Sateesh,
I couldn't follow all of your remarks in your last response, but if I get it right, your main concern seems to be that the total amount of tera bytes required to store databases for all users is too large to be stored on a single machine.
Databases in BaseX are already pretty small, compared to other native XML stores, and of course we try to keep their size as small as possible, so there is no way to shrink them to half of their way. However, if your queries do not take advantage of the text index structures (text and attribute index), you can disable them before creating a database, or remove them after the creation, and you will save some additional bytes.
Of course, you can always think of removing databases from users that are not using the system anymore.
Best, Christian
#Sateesh1: We create databases and we use them to retrieve user information,as each time creating databases and deleting them takes some time what we are doing is we run an offline tool and creates those databases so that when user chks his details online the users will get the response more faster.With this approach what is happening is as we have around 10k users and each user will have a xml getting generated every month and also basex DB's getting created for those xml's is requiring TB's of storage,for this is there any option in basex which will create DB sizes equal to xml size or less than xml size's(Currently if xml size is 10mb DB size is creating as 20mb approx).
Thanks & Regards SAteesh.A