4 ms·
Thanks for your honest opinion sfphotoarts. I would say in defense that: - The return time doesn't scale with the number of rows returned. I have just run a
by samh 17y ago
Thanks for your honest opinion sfphotoarts.
I would say in defense that:
- The return time doesn't scale with the number of rows returned.
I have just run a query that queried 6 tables, invoked numerous string concatenations, included 2 MOD functions, 2 RAND functions and returned 22,000 rows, it took 11 seconds. This is not up to database performance of course.
- There is a static overhead to running a query, and that's much greater in QueryCell than in a database directly.
- QueryCell is not meant to replace databases, just make life easier for people working in Excel.
It was pretty much the 'countless hours trying to use formulas' that made me think about QueryCell.
Cheers