I used in the past phpmaker 2023 and I recently installed phpmaker 2025 trial to test and consider buying it.
I have a form based on “request” tabel in which I use a modal lookup that is related to table “clients” in which I have around 25.000 records.
The data in the modal search are loading very slow it takes about 5-6 seconds to load with the code generated by phpmaker 2025.
In phpmaker version 2023 loading time was around one second using same project and same settings.
I tried also with lookup caching and without no big difference.
Any idea why is this slow loading?
If you have so many records, it is slow. Even the 25000 records are cached (by default lookup cache is not used for so many records), the browser still takes time to load it. Avoid using simple lookup for such huge tables. You may use AutoSuggest (i.e. TEXT Edit Tag) instead, or enable Require search feature to let user enter some criteria first.
I use a modal dialog for lookup with option to add records.
Can limit results displayed in modal window
I was wondering why in old version loading was better?
Can I limit the results displayed firstly eg. to display only 10 records and if user type to start search?
I tried both AutoSuggest (i.e. TEXT Edit Tag) and enable Require search but still are loading all records by default in the modal window.
If I don t use modal seems to work.
There is a way to start search for require search after typing 3 charcaters not only 1?