I wanted to join in on this thread and add my experiences.
I have a access Fe, sql 2019 be.
In some instances, especially searches , sql seems to be much slower that just a split database. Im sure this is just because I havent designed the forms/queries with sql in mind, however its important to note, out the box, this is just how it is.
People keep saying indexing is the answer for this, it doesnt help.
Here are the results of my experiments.
Table1, 1 column , which is the pk, indexed, has 3000 rows of data, eg 3000 records of one integer which is the PK.
This is a fairly "light" database, and yet still there is a major issue.
If i just open the table, it loads near on instantly, to quick to measure by the human eye.
If i open in a bound form, with just one text box, then search for a specific record, it can take around a minute to find the record. The pc specs are irrelevant, tried on multiple pcs different hardware, same, , and so is network setup, its the same on the local network as remotely etc
Obviously this is not an ideal situation.
For reference, with the same setup, a split access setup can find the record in about 1 second.
Does anyone have an advice ?