densma
|
Posted: 03/03/2004, 8:27 AM |
|
CCS generated pages is too slow...... i though CCS WAS COOL
i have search and grid on separate pages..
i have like 1500 records and no joins.. created index same thing.
i Use a diff program to a page with search and grid.. runs 70% faster than CCS page on the same table..
in CCS when pulling 100 per page takes for up to 30-40 sec.
how can i optimize ccs generated page?
|
|
|
DonB
|
Posted: 03/03/2004, 10:39 AM |
|
What's the "other" program? What's the database?
Something else is your bottleneck. The CCS code is regular, and fairly
tight, ASP code. A 70% discrepancy is going to involve some other factors
than just the code. Perhaps the other program has extracted and cached the
page so that it is not executed except on the first "hit"? This is fine for
relatively static output, but obviously not good for data that changes
moment to moment.
Script blocking virus checkers can slow down or stop the page execution.
--
DonB
http://www.gotodon.com/ccbth
"densma" <densma@forum.codecharge> wrote in message
news:640460779631f6@news.codecharge.com...
> CCS generated pages is too slow...... i though CCS WAS COOL
> i have search and grid on separate pages..
> i have like 1500 records and no joins.. created index same thing.
> i Use a diff program to a page with search and grid.. runs 70% faster than
CCS page on the same table..
> in CCS when pulling 100 per page takes for up to 30-40 sec.
> how can i optimize ccs generated page?
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
densma
|
Posted: 03/03/2004, 11:15 AM |
|
aspmaker 3 runs faster with 'no cache' but i like CCS better.
classic asp with sql 2000
what's "Script blocking virus checkers? "
honestly, these pages run faster with aspmaker. but i can do more with CCS. Im sure should be a way to optimize this.
|
|
|
peterr
|
Posted: 03/03/2004, 11:16 AM |
|
densma,
Take a look at http://support.codecharge.com/kb_search.asp?s_keyword=&...pularity&s_cat=
This page was generated with CCS, shows over 50 results, usually in 2 seconds, using JOINS, and MS Access database...
I have no idea how you can achieve 30-40 second response, but if you contact our support we can try to analyze this issue for you.
_________________
Peter R.
YesSoftware Support Representative http://support.codecharge.com
Warning: I use Google and CCS Docs/Examples in most of my answers
---------------------------------------
Sent from YesSoftware forum http://forums.codecharge.com/
|
|
|
peterr
Posts: 5971
|
Posted: 03/03/2004, 11:17 AM |
|
densma,
Take a look at http://support.codecharge.com/kb_search.asp?kb_articlesPageSize=55
This page was generated with CCS, shows over 50 results, usually in 2 seconds, using JOINS, and MS Access database...
The whole database is 80MB and for example has over 65000 records in one of the tables, which we use frequently.
I have no idea how you can achieve 30-40 second response, but if you contact our support we can try to analyze this issue for you.
BTW, which database are you using?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
densma
|
Posted: 03/03/2004, 12:42 PM |
|
ok,
im using sql 2000
is it possible to generate code with Standard asp without templates?
|
|
|
peterr
Posts: 5971
|
Posted: 03/03/2004, 1:11 PM |
|
CCS generates only ASP with templates.
When contacting our support, please also specify how are you connecting to MS SQL (SQL driver or ODBC).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|