peterr
Posts: 5971
|
| Posted: 03/06/2009, 3:37 PM |
|
Hello everyone,
We are testing a new CCS version 4.2 that should be released within a few days but it looks stable and no more changes are expected, therefore I'm posting it initially here:
http://download.yessoftware.com/CCStudio4_2.exe
This is mainly a bug fix release, but includes new CAPTCHA feature that we developed internally (not a 3rd party component). The list of bug fixes will be avalable shortly.
CAPTCHA can be used within record forms like other controls (textbox, listbox).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
 |
quasimidi
Posts: 151
|
| Posted: 03/07/2009, 3:52 AM |
|
Awesome! Waiting for the details Peterr!!!
Update: the captcha component is ok, needs some more documentation and usage example.
_________________
RS |
|
|
|
Jan K. van Dalen
|
| Posted: 03/07/2009, 2:27 PM |
|
Ahaaaaaaaa ... I thought 5.0 was the next one :)
Thanks for 4.2
"peterr" <peterr@forum.codecharge> wrote in message
news:249b1b3a09e10a@news.codecharge.com...
> Hello everyone,
>
> We are testing a new CCS version 4.2 that should be released within a few
> days
> but it looks stable and no more changes are expected, therefore I'm
> posting it
> initially here:
> http://download.yessoftware.com/CCStudio4_2.exe
>
> This is mainly a bug fix release, but includes new CAPTCHA feature that we
> developed internally (not a 3rd party component). The list of bug fixes
> will be
> avalable shortly.
> CAPTCHA can be used within record forms like other controls (textbox,
> listbox).
>
> _________________
> Peter R.
> YesSoftware Forums Moderator
> For product support please visit http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/08/2009, 1:15 AM |
|
Yes, Captcha probably could be delayed until 5.0, but mainly we work on various individual features and then decide if they could warrant a major or minor upgrade. In this case Captcha was ready while other new features still need more time.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/08/2009, 6:54 AM |
|
Peterr i will beg, for the change of every Include page opening a new Connection to the database, that is killing us badly. a page with 12 Include is opening 12 Connection to the Database, its not a bug but is an Issue for us now that we decided to go .
as a solution we have to get a new Server with 8CPU and 12GB just cause that (64bit)
Please Please Please
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
datadoit
|
| Posted: 03/08/2009, 7:07 AM |
|
Oper wrote:
> Peterr i will beg, for the change of every Include page opening a new
> Connection to the database, that is killing us badly. a page with 12 Include is
> opening 12 Connection to the Database, its not a bug but is an Issue for us now
> that we decided to go .
>
> as a solution we have to get a new Server with 8CPU and 12GB just cause that
> (64bit)
> Please Please Please
Not seeing how this is either a 'bug' nor is there a 'fix' for CCS or
any other IDE out there on the market. This is a design methodology
that certainly would require more hardware, bandwidth performance, and
hands-on database management if there are more than a few dozen
simultaneous users.
I want to drive a parade float to work everyday, so I think the
government should make wider roads to accommodate that. :)
|
|
|
|
datadoit
|
| Posted: 03/08/2009, 7:18 AM |
|
joejac wrote:
> What Oper mention is a terrible issue in a shared server environment, were
> connections are very limited.
> Hope Yes consider this asap.
> Thanks a lot
> Regards
> joejac
> ---------------------------------------
I can't disagree with this more! ;)
-If- your design practice requires many simultaneous database
connections, and -if- you have more than a few visitors to your site,
then you certainly should not be in a shared environment.
We've already been kicked out of a shared hosting environment because of
this reason by the hosting provider. We switched to dedicated hosting
which worked for a while, and ultimately to an in-house clustered
environment which works perfectly. It's growth. We weren't arguing
because we liked the traffic!
Again, me don't thinks this is a CodeCharge IDE issue.
|
|
|
|
joejac
Posts: 242
|
| Posted: 03/08/2009, 7:55 AM |
|
What Oper mention is a terrible issue in a shared server environment, where connections are very limited.
Hope Yes consider this asap.
Thanks a lot
Regards
joejac
|
|
|
|
Gena
Posts: 591
|
| Posted: 03/08/2009, 7:56 AM |
|
Not yet installed 4.2. So, Oper, could you clarify what does it mean "opening a new Connection" in every Include page? if I have Include page just with few line of code - why you need a new Connection?
_________________
Gena |
|
|
|
roeya
Posts: 181
|
| Posted: 03/08/2009, 8:06 AM |
|
Quote Oper:
Peterr i will beg, for the change of every Include page opening a new Connection to the database, that is killing us badly. a page with 12 Include is opening 12 Connection to the Database, its not a bug but is an Issue for us now that we decided to go .
as a solution we have to get a new Server with 8CPU and 12GB just cause that (64bit)
Please Please Please
In Perl we use something called "cached connection" - so every time the program tries to connect to the database it checks if there is already an active connection and then use it. The feature is implemented in Perl and CCS supports it,
I saw in the documentation that PHP has similar "Persistent Connection: Select this option so that opened connections are reused whenever available. "
_________________
http://www.infoneto.com/ |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/08/2009, 10:19 AM |
|
maybe you dont get what i try to wrote maybe my English. Sorry
Let try to explain:
we have been trying to get a free CMS in Codecharge with free Source out
something like this:
http://www.PioDeportes.com
http://www.Informatica.com.do
1 page with 10 simple include just to make things easy
2 or 3 Included Grid to show Some data
1-2 Included Grid to show Random Image
1-2 Include Grid for main Display
1 Include for header
1 Include for Footer
CMS/Forum easy somethign easy that anyone could modify with CCS akcnowledge
but we have to wait for some solution from yes.
Every include is creating a New connection to the Database (not right)
http://www.Informatica.com.do/CCS/SomeImage/MultiConnection.jpg
This image is just only 1 Visit and look the amout of connection 1 for every INCLUDE
if you code without including and just copy/paste every piece of grid/form in very page
just one connection is opend to teh database. no matter how how many visitor you have
just get, 20 Customer will open more than 250 Connection to the database (not right)
and just 1 Visitor to each page will open 250+ Connection
as a solution you have 2 choice
1: a huge server
(note: we have not used shared hosting since 2003)
2: Alter CCS code to make the variable and Connection (DBConnection1 Public)
and be Used for all Include, but that make that application not upgradeable
casue grey text has to be changed.
if anyone have any solution for this (WELCOME to heard) cuase
Support said change the grey part for now.
Gean,
if the include dont have a form or Grid (everthing is OK)
NOTE: this is not 4.2 version has been there for ever.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/08/2009, 10:30 AM |
|
The basic Problem in ASP i dont know in other is this:
Set DBConnection1 = New clsDBConnection1
DBConnection1.Open
and DBConnection1 is Private for Every Include (so every include will open a new Connection)
of course the connection will stay open for few seconds till MySQL or MSSSQL closed
for inactivity but ............ (just 1 Visitor on 40 Customer will hit badly any server)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Gena
Posts: 591
|
| Posted: 03/08/2009, 10:31 AM |
|
why don't you try to use "Persistent Connection" in your Connection settings?
_________________
Gena |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/08/2009, 10:45 AM |
|
maybe you are refering to this:
http://support.yessoftware.com/kb_article.asp?article_id=50
Only PHP
I started a new project using PHP and i get that screen,
Thank Gena to Try (i almost jump from my chair with satisfaction) :)
Still looking for solutions, maybe i'm missign somthing but support said modify Grey TEXT (something i dont want todo)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 03/08/2009, 11:06 AM |
|
Quote Oper:
Support said change the grey part for now.
by "grey part" I assume you mean the CCS generated code? if that is what support suggested that may be the only way.
why not rewrite your CMS so you don't use all the includes? maybe have all of these grids stored as code snippets in a library area and whenever the CMS builds a page it grabs what it needs and integrates into a complete page ready for display? let your CMS do the heavy lifting of page construction/final assembly (not real-time).
most CCS users are probably creating applications while you are creating something more like CCS itself, a CMS or application generator. it seems reasonable that such a complex application may require some complex additional coding on your part. maybe even in the "grey part"! :)
_________________
Walter Kempees...you are dearly missed. |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/08/2009, 11:17 AM |
|
is not about complex JCC
just one small Page let said a normal page
1 Include for Top Header
1 Include for Bottom Footer
1 Include For LeftSide Menu
and the main Screen.
in CCS ASP will be 4 Opened Connection (not right) of couse in Shared enviroment
that must of the user use you will get Kicked out like Datadoit said just for a Small page.
and solution is really simple modifyng Grey TEXT (CCS Generated Code)
just need to create a Public DBConnection1 variable (tha's all)
but CCS is a Trouble Upgrading working clean, guess what will happend in another upgrade if you do that kind of change.
Also i dont care changing (CCS generated Code) we just documented and take care of those
change during Upgrade.
as example we modify Common.xxx for few reason
1) Generate a Log of every SQL excuted in Case DEBUG is on
2) CCDLookup is Changed to meed our need and Error Control etc.
but those are eally Puntual need for us. but Connection Open for every Include
is not just us is Everyone using ASP.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
datadoit
|
| Posted: 03/08/2009, 11:46 AM |
|
I think that if you don't have to deal with a record form or an editable
grid in your includes, then (if it were me) use custom code to create
the connection, get the data you want, then close the connection.
That alone would eliminate many of your connections perhaps?
However, I do like the idea of the IDE in some magical way handling
connections across includes, but I don't see it happening. I also don't
want it to sidetrack the Yes folks from making the application more
stable. Seems over the last year or so they got sidetracked on
Artisteer and AJAX nonsense that took away from the stability and
purpose of the application itself. Both of those features I believe
should have been offered as plugins at extra cost with their own sales
and support departments.
But that may be just me... :)
|
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 03/08/2009, 11:56 AM |
|
I guess I may not fully understand the issue.
for example, if I create a new page in CCS (ASP) with a search and a grid and a record. will it require more than one connection?
_________________
Walter Kempees...you are dearly missed. |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/08/2009, 12:13 PM |
|
Quote JimmyCrackedCorn:
I guess I may not fully understand the issue.
for example, if I create a new page in CCS (ASP) with a search and a grid and a record. will it require more than one connection?
No. Just 1
---------
the issue come when you use and include on that Page
and the include need a Connection let said
a grid that you want to use on all pages like left side menu.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/08/2009, 9:02 PM |
|
Oper,
I'll check into this, although I don't know why this happens and if this issue can be easily solved in ASP. Based on above comments this looks like a database connection feature supported by other programming languages like PHP and Perl.
I also haven't seen such issue with multiple connections in ASP.NET. You may even want to consider using ASP.NET in future projects as it can be 10x faster than ASP or PHP and therefore requiring less hardware, plus you can include pages dynamically at run-time.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
TonyReid
Posts: 159
|
| Posted: 03/09/2009, 2:12 AM |
|
I was wondering if we could see the changelog for the PHP side of this release, as I need to see what bugs were fixed before rolling it out.
Sorry for being cautious, but new releases of CCS have bitten my backside before and I need to make sure.
Thanks in advance,
Tony
_________________
-----------
PHP/indy Game Developer - http://www.AbsoluteBreeze.co.uk |
|
|
|
datadoit
|
| Posted: 03/09/2009, 4:52 AM |
|
peterr wrote:
> You may
> even want to consider using ASP.NET in future projects as it can be 10x faster
> than ASP or PHP and therefore requiring less hardware ...
REALLY? So the millions and millions of LAMP developers out there have
been missing out on the wonderful world of proprietary Microsoft speed
and simplicity?
|
|
|
|
Oper
Posts: 1195
|
| Posted: 03/09/2009, 7:00 AM |
|
Quote peterr:
Oper,
I'll check into this, although I don't know why this happens and if this issue can be easily solved in ASP. Based on above comments this looks like a database connection feature supported by other programming languages like PHP and Perl.
I also haven't seen such issue with multiple connections in ASP.NET. You may even want to consider using ASP.NET in future projects as it can be 10x faster than ASP or PHP and therefore requiring less hardware, plus you can include pages dynamically at run-time.
Thank Peterr, just a reply into that isue is ok for me.
Also right now we use ASP.NET
But like you already know we have 3 CCS License and the new Guys are learning ASP.NET
(They both own the License and we teach them how to used, but there main language is ASP 3.0)
and i dont think will be hard to change the ASP 3.0 behavior (maybe its)
but the issue come that every include is a Class and every Class is opening a new Connection
if i edit every class and use the Main Connection, and coment every new Opening just 1 Connection is used.
who know's maybe the change is hardest than i think on CCS Code.
Thank again.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/09/2009, 12:06 PM |
|
Quote datadoit:REALLY? So the millions and millions of LAMP developers out there have
been missing out on the wonderful world of proprietary Microsoft speed
and simplicity?
They can use Java, but this response was to Oper who is already using Microsoft's ASP.
I wouldn't even dare to mention ASP.NET to someone using PHP 
Though for me LAMP is not less proprietary than commercial products since I have no idea how to nor the time to change MySQL or PHP source code even if I don't like something. I use LAMP for price and ASP.NET for performance.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 03/09/2009, 12:28 PM |
|
"TOOL FIGHT!!!!!"
_________________
Walter Kempees...you are dearly missed. |
|
|
|
quasimidi
Posts: 151
|
| Posted: 03/10/2009, 10:25 PM |
|
Gentlemans,
Before sending a bug report, I want to ask some help from CCS users (v4.2):
Could you guys check if the IDE is crashing when using space in a custom Style name, and try to modify that style.
Thanks,
Robert
_________________
RS |
|
|
|
kevind
Posts: 251
|
| Posted: 03/11/2009, 4:41 AM |
|
I assume this would be true of ASP & MS Access databases using DSN-less connections ?
I generally use one page as a presentation layer with YUI layout, then setup the grids and records etc on includ-able pages where i can test and debug them much more easily.
So, if this is true about multiple connections it might explain why I get sucky performance in a shared server environment and this is a small app.
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
roeya
Posts: 181
|
| Posted: 03/19/2009, 7:42 AM |
|
Quote peterr:
Hello everyone,
We are testing a new CCS version 4.2 that should be released within a few days
Any update on this ?
_________________
http://www.infoneto.com/ |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/19/2009, 5:57 PM |
|
Quote kevind:
I assume this would be true of ASP & MS Access databases using DSN-less connections ?
I generally use one page as a presentation layer with YUI layout, then setup the grids and records etc on includ-able pages where i can test and debug them much more easily.
So, if this is true about multiple connections it might explain why I get sucky performance in a shared server environment and this is a small app.
kd
Yes kein will open one connection fro every Include page, casue every include use a private Variable for connection, BUT BUT :) it will be fixed in some of the next release
(already talk about this with Develop team,etc)
in MYSQL is easy to reproduce cuase you could see how many
Connection are open at the very moment you click.
in Acces ther is no way to check that.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/20/2009, 3:02 AM |
|
Hi All,
We've decided to squeeze in couple more improvements, one for Oper discussed above because it looked like an important problem. We've also updated the Ajax Example Pack with instructions on how to reproduce those examples.
CCS 4.2 is now live on our website:
http://support.yessoftware.com/updates.asp
Oper,
We couldn't fully resolve this issue due to ASP handling database connections differently, but we've limited applications to using one connection per includable page level. Therefore multiple includable pages will utilize one extra connection, while pages included into those includable pages will add one more connection.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
