Querying a table with over 60k records
Is there simply no way to use a formula query on a table with 50k+ records? I've tried having a first query that would elimante all but a handful of options but I still get the 'will take too long er...
Forum Discussion
What queries have you tried so far? What is the field type you are trying to query?
The answer I always get from QB about formula queries is they don't work well for large data sets or tables with a large number of relationships.
------------------------------
Paul Peterson
------------------------------
I have 3 fields I can use in my query. An 'Amount' field, which if I queried should probably return a max of 100 results, a project ID field which could return up to 1200 results, and another text field that would return like 20k results. But all 3 should only return a couple results max. So i tried to query the Amount first, then the project ID. I shouldnt even need the last field to be honest. I also tried the reverse, query project ID then AMount.
I am trying to query on a synced table, so I am thinking maybe that is it? But I thought synced tables were just seen as straight data, so maybe its just the 60k records.
I cannot find a work around though for my issue. I might start a new thread with it.
------------------------------
Mike Tamoush
------------------------------
I am trying to query on a synced table, so I am thinking maybe that is it? But I thought synced tables were just seen as straight data, so maybe its just the 60k records.
I cannot find a work around though for my issue. I might start a new thread with it.
------------------------------
Mike Tamoush
------------------------------