BookLibrary Wishlist

Hello Taras,

What all areas we should look to tune if we want to improve bookslibrary performance?

I do have a VPS server where bookslibrary is hosted and so what all tuning you suggest to do at server level to improve performance.

Also, can we add any additional indexes on other fields of bookslibrary tables which can improve performance without causing any functional breakdown to bookslibrary pro software?

Space is not a concern.

Please suggest. Thanks.

regards,
parag

Hello,

It is not connect with our component. It is question to your host provider.

Thanks,
Taras
OrdaSoft team.

Taras,

Let me tell you how is this question relevant to your books library.

Firstly, i am making reference to bookslibrary and not VPS server based objects.

1) Given bookslibrary mysql db design, does bookid have a unique key index? Especially when the product is configured to treat Bookid as unique and not ISBN id as unique?
2) Which all columns would you recommend to have index to improve performance ? books_title, bookid, etc ?

My intention is to ensure that table scans are reduced by indexing any additional important fields which are searched on a regular basis.

Hope my queries are now pointing to bookslibrary software/db and look relevant.

Basically, your products successful implementation and use is our success and yours as well.

thanks,
parag

hello Parag,


If you know what is it index - please go to your database - and you will see all indexes what we have in booklibrary

Speed optimization - very big and long process - it depend from every end your site page.

Impossible say about speed - without real page and all sql requests on that page.

so you need do optimization - for every requests

In book library all Primary keys - that ID, all other need check for exactly sql requests

Thanks,
OrdaSoft team