Originally Posted By: Andrew Bates
Like Support, I'm surprised to hear that the GridView inquiry is taking that much longer than the equivalent SalesAnalysis Inquiry.

If you would like to "File | Gather Files for Support" for your GridView example and upload it to https://portal.softrak.com/dbr to my attention, I'll take a look in some upcoming airport departure lounge and try and figure out why the View is taking do long to process.


Andrew,

I have uploaded the GV file as you requested; the title should have your name in it.
I also got some statistics for you when we refresh the data for these gridviews.
When we refresh ANY data pulling from the S/R Transactions table it is querying 336,904 items currently. In the GV I have sent you, it is selecting 175,000 lines from the total which takes 3.5 minutes every time we refresh data. You can see why this is frustrating for our sales team in today's world of speed.
~
Let me know when you have had time to look at the data
Thank you,
Jason


Edited by Jason (10/16/18 03:06 PM)