I'm self-taught in QV so apologies now for any simple mistakes.
I have a database with millions of entries and although the performance of my app isn't terrible it takes about 7 seconds to load when a selection is changed.
I think I could improve my structure to help with this. Here's what I currently have:
All of the tables one the left are linked by the %Key, which links then to the MasterTable and then the MasterTable is filtered by other tables (my options).
I wondered if anyone could advise me what I could do to improve this structure? I'm fully up to speed with joins / union / concatenate etc. but I don't know what works best in QV, many small tables or one huge table? Maybe I could concatenate all the tables on the left?
Any tips / suggestions would really be appreciated.
I would recommend looking around in the Design Blog area for additional info as well, may be some other posts that that may be of additional help too, but hard for me to know exactly what you need, and I am not a very good developer myself, so hopefully this gets you on the right track with things.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.