songohan
Posts: 89
|
| Posted: 09/23/2007, 9:08 AM |
|
On single page I have few panels, in each one there is include page or component (grid, record whatever). Based on URL params I show one or more panels.
What I wonder is what happens with components that are not shown, is their code executed on server? Is this technique slowing down the application?
If I have 10 panels and each has grid inside, will select and HTML generation happen for all of them even if I show just one?
I like this method because I can use single page (eg index.php) to render all site. Till now I did not notice any side effects but I wonder what will happen when database grows bigger and more records is selected.
Is this technique OK or it is better to generate separate page for each set of components needed?
Thnx,
Andrej
|
 |
|
wkempees
|
| Posted: 09/24/2007, 3:58 AM |
|
From the Helpfile:
Quote :
Restricting SQL Execution for Components Hidden Using a Panel
When using PHP, ASP or Perl; hiding a panel means that SQL queries will not
be performed for any form included into the Panel. When using Java or .NET
the data reading is performed prior to it being displayed, therefore it is
necessary to use custom code that sets the component's AllowRead property to
False if panel's Visibility property is False. The following custom code can
be added in the page's After Initialize and component's Before Select
events:
Also note that CCS 3.1 introduced a setting in Project Settings
Quote :
a.. Exclude missing form fields/parameters from data updates
Specifies the default processing method for missing form fields and
parameters. This feature was introduced in CodeCharge Studio 3.1 to improve
the functionality of the Record and Editable Grid components. When this
option is enabled, any fields that are hidden within a form (and therefore
missing when submitted) will be excluded from the INSERT or UPDATE statement
and therefore preserving previous database values. When disabled, hidden
fields will be saved into database with null values, clearing any previous
value already in the database. Fields may be hidden either by placing them
within panels or by setting field's Visible property to "No" or "Dynamic".
Note: this option doesn't apply to Custom Insert and Custom Update features
as they provide corresponding options and can be used to override this
default value at form level.
To handle field values in hidden panels.
Hope this helps.
Walter
|
|
|
|
songohan
Posts: 89
|
| Posted: 09/24/2007, 3:04 PM |
|
Thnx,
I deserve you to say to me RTFM :)
Thnx a lot
Andrej
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 09/25/2007, 6:04 AM |
|
Andrej
Quote :
I deserve you to say to me RTFM :)
Not meant that way, although it would have been a good answer too 
But your question was more complex.
Keep asking/posting, do not let us scare you of.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
 |
|
|
|
