Handy Library Manager
 for Windows


Help, how to topics > Library Main Catalogue > What is the maximum number of records the software can handle?


What is the maximum number of records the software can handle?

There is no limit on the number of items or patrons you can catalog with our database system. The size of the library database is determined by your system's capacity. Handy Library Manager utilizes the Firebird SQL database system. In a single table, you can store approximately 32 TB of data, with a maximum number of rows (which corresponds to the number of items in your library) reaching up to 16 billion. This information is based on the Firebird Technical Specifications from 2015.



Question:
I'm wondering how many items we can store with this software? We have document library with approximately 2000 items that we would track. Also, our agency has two offices with a lending library, will we need to purchase two applications?

The school is looking at buying a program for the library and we would like to know many records, books, DVDs, articles and text books can this database hold or handle.

What is the storage capacity for this software? We have a small library of maybe 10000 records.

We are looking at getting this program for our small library. How many books can we enter into the database?


Answers:
There is no limit to our system's capacity. We have assisted libraries in setting up the system to manage up to 20,000 items, and we have tested it with 40,000 items. You can easily track more than 10000 items. A library with 15000 records typically requires about 10 MB of disk space.


Question:
I noticed the website indicates that the application is ideal for libraries with up to 20,000 items. I already asked this question and was answered that there was no limit on the number of items or patrons that can be catalogued with the database system. Can you please clarify, what happens if we have more items to catalogue?

Answers:
Having a very large number of library items may delay the display of the Main Library Catalogue window, as the grid will load all items. To improve loading speed, you can define the Display Page Size in the Options menu.


Question:
Large library of 70,000 items. You specify 20,000 limit on your library software. What are the limitations of your program.

Answer:
There is no limit to the number of items you can enter and manage. We could create a demo library with 70000 items and send it for testing.


Copyright © 2025 · All Rights Reserved · PrimaSoft PC