Skip to Content (Press Enter)
2024-04-16 10-48-56
samuel frade
43Views
2Comments
SQL - Count total rows - What are the pros/cons of WIHT CTE vs DO 2 queries?
Discussion
Performance
SQL
Best Practices
Traditional Web

I would like to know the pros and cons of using a WITH CTE vs 2 QUERIES (GetTotal and GetOffeset)
Considering:
- Performance
- Best Practices
- Rich widget set up for table pagination and list counter 


VS
and


Thank you šŸ«¶

0
0
19 Apr 2024
Copy Link
2024-04-16 10-48-56
samuel frade

CONS 

1 - Set up configuration of rich widget and others may be so straightforward...
           1.1. List_Counter:

       1.2. List_Navigation

                

            

           1.3. Table Data 

           1.4. Query Refresh



 


0
0
30 Apr 2024
Copy Link
2019-04-09 00-57-55
carl ruhle

Hi Samuel, 

in my humble opinion I would bet on the query option, later on it should be simpler to update/change the way the select is made, but that's my opinion with no "numbers" to say witch is better or worse.

Regards 

0
0
18 May 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.