Ron Sherman
|
| Posted: 02/11/2003, 8:50 AM |
|
I have been using Code Charge and only recently downloaded CC Studio to
evaluate.
While I find that CCS has a lot more features, I am a little concerned about
the performance of the generated applications.
Looking at the CCS generated code, I see a lot of overhead - in terms of
classes, controls, event handlers etc - created for even the simplest
forms, compared to CC ( I am testing ASP 3.0 w/templates). So even a small
CCS application appears to require a lot of Server Resources - in terms of
memory and CPU - to deploy and run. While this is OK for a simple site - how
does this affect large, busy sites ? Does anyone have any comments /
experience on how this affects performance on a live production server ?
Thanks
- Ron
|
|
|
 |
RonB
|
| Posted: 02/11/2003, 9:52 AM |
|
My companies intranet runs on win2k(P4 1Ghz,512MB), apache, mysql,php. It
has 350+ users .
I designed the intranet entirely with CCS and the speed is great.
Performance only drops when a connection is made to an oracle 9i database
wich holds our client-registration database. The drop in performance is
caused by the oracle 9i server. Pobably because of poor streamlining on the
count of our database supplier that still does maintainance. The performance
is as low as the performance when using our client registration software,
build by the same supplier.
The intranet is lightning fast and I have had no complaints.
RonB
"Ron Sherman" <wizzerd1024@yahoo.com> schreef in bericht
news:b2b9km$u77$1@news.codecharge.com...
> I have been using Code Charge and only recently downloaded CC Studio to
> evaluate.
> While I find that CCS has a lot more features, I am a little concerned
about
> the performance of the generated applications.
>
> Looking at the CCS generated code, I see a lot of overhead - in terms
of
> classes, controls, event handlers etc - created for even the simplest
> forms, compared to CC ( I am testing ASP 3.0 w/templates). So even a
small
> CCS application appears to require a lot of Server Resources - in terms
of
> memory and CPU - to deploy and run. While this is OK for a simple site -
how
> does this affect large, busy sites ? Does anyone have any comments /
> experience on how this affects performance on a live production server ?
>
> Thanks
> - Ron
>
>
|
|
|
|
Imran
|
| Posted: 02/11/2003, 10:30 AM |
|
I've done a pretty busy site using regular CodeCharge. It averages about
3,500 visits per day (visits, not hits). It's on a server running about 15
other sites, 2 or 3 of which are about half as busy, and a few other sites
which get at least a couple of hundred visits per day. Almost all of these
sites (all of the busy ones) use CC or CCS.
I've never experienced any issues with server performance that are cause for
any kind of alarm. On the contrary, I'm always pleasantly surprised by the
performance of all these sites running together on one server. The server is
a dual PIII-800 with a Gb of RAM. And we use MS SQL Server.
"Ron Sherman" <wizzerd1024@yahoo.com> wrote in message
news:b2b9km$u77$1@news.codecharge.com...
> I have been using Code Charge and only recently downloaded CC Studio to
> evaluate.
> While I find that CCS has a lot more features, I am a little concerned
about
> the performance of the generated applications.
>
> Looking at the CCS generated code, I see a lot of overhead - in terms
of
> classes, controls, event handlers etc - created for even the simplest
> forms, compared to CC ( I am testing ASP 3.0 w/templates). So even a
small
> CCS application appears to require a lot of Server Resources - in terms
of
> memory and CPU - to deploy and run. While this is OK for a simple site -
how
> does this affect large, busy sites ? Does anyone have any comments /
> experience on how this affects performance on a live production server ?
>
> Thanks
> - Ron
>
>
|
|
|
|
Jan Hoeve
|
| Posted: 02/11/2003, 11:38 PM |
|
if you have a large table in your database (mine is > 200 MB), then you
check your queries. What ccs does when you have a grid/record page is the
following:
"SELECT * FROM table inner join anothertable on id1=id2".
Note: this is without the where component. You can imagine that with a very
large table, it does take quite a time to finish this query.
So, in the query builder you can set the default value for the id on -1. You
then get "SELECT * FROM table inner join anothertable on id1=id2 WHERE
id2= -1" . This speeds up a LOT!! And no functionality is lost.
grtz,
Jan
"Ron Sherman" <wizzerd1024@yahoo.com> schreef in bericht
news:b2b9km$u77$1@news.codecharge.com...
> I have been using Code Charge and only recently downloaded CC Studio to
> evaluate.
> While I find that CCS has a lot more features, I am a little concerned
about
> the performance of the generated applications.
>
> Looking at the CCS generated code, I see a lot of overhead - in terms
of
> classes, controls, event handlers etc - created for even the simplest
> forms, compared to CC ( I am testing ASP 3.0 w/templates). So even a
small
> CCS application appears to require a lot of Server Resources - in terms
of
> memory and CPU - to deploy and run. While this is OK for a simple site -
how
> does this affect large, busy sites ? Does anyone have any comments /
> experience on how this affects performance on a live production server ?
>
> Thanks
> - Ron
>
>
|
|
|
|
|
