MySQL

Memory is good. But XP has a 4gb limit. This server should be enough, unless you are working with
gigantic ))) amounts of data on a Pentium processor. Yes, the server is important. But...
I would pay attention to query optimization from MVD. The MYSQL server has the ability to log "slow queries"
with information about the request, the text of the request, the execution time, the amount of information
transferred. You will be surprised at how much information is requested by the program. This will help you
understand bottlenecks in a program or server. Usually this is the output of information to the table to the
maximum as in excel - everything on the screen, filling in combos, filling out all forms at once. All this leads
to the formation and loading into the program of a large amount of information, often not needed. Receiving
small portions of data, filtered and needed at a given time, is much more efficient. Attention should also be
paid to the processing of information in tables. Formatting data in columns (text and number format), data
sorting. Sorting data in a SQL query is much more efficient than in a program with a large amount. Well, etc.
You may have to write some queries yourself instead of automatic programs, which will be more efficient.
In the script, supplement or replace additional dbFilter filters in queries when starting forms and filling in key
combos. The downside may be the need to manually track table changes and update program data.