Paul,
The super view idea is a conditional yes. It all depends on tables and views
involved.
One key idea to remember is that the order of selection is VERY important.
The selection of tble actions should proceed from the most restricted selection
(seleccts the smallest number of records) to the least restricted. The idea is
if you start with the smallest number of records each subsequent addition to
the sequence will return fewer records. Remember to consider using nested INNER
and OUTER JOINS. until the nesting of joins was introduced I had as you do a
series of selection using views of views. Now I have reduced them to "super
views" for better performance.
Jim Bentley, American Celiac Society 1-504-305-2968
On Wednesday, April 25, 2018, 2:59:51 PM CDT, Paul C. Buckley
wrote:
Good afternoon,
I’m using the latest version of R:BASE X Enterprise. I’ve got multiple SQL
tables from a SQL database sattached. I’m creating multiple views from a
combination of attached SQL tables and R:BASE tables. Each is a view linking
the previous view and another table/view or 2. The performance on using the
final eighth view is getting very sluggish. I’m wondering if it’s worth the
effort to create a single “super view” that contains all the tables & views and
various where clauses.
Any thoughts or suggestions would be greatly appreciated.
Thanks,
Paul Buckley
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.