jm
|
| Posted: 07/28/2004, 4:58 PM |
|
Hello
Can some please let me know how efficient the CCS will produce code optimized for speed. The project will be run locally
for inventory type of an operation?
Thank you
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 07/29/2004, 2:11 AM |
|
I can't answer what others may think about the efficiency or speed of the code, however I'd like say that this is a relative topic. Java code is much different from .NET and PHP, ASP, etc. Each one is written differently and may execute with different speeds as well.
I would say that if you cannot run an application created with CCS then probably you won't be able to run other applications too, and may need to add extra Web servers.
Usually you should be able to execute a minimum of 10 pages/second (up to 100 depending on the hardware and software), which comes to 36000+ page views per hour. If your operation is nearly that busy then you may need to evaluate the technology and database choices, run your own benchmark tests to determine how much hardware you may need, etc.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
jm
|
| Posted: 07/30/2004, 10:18 AM |
|
Hi
Here is one observation, I have download the demo and here it is
in an table with 50 entry's in it the CCS has not a problem running locally it is quite fast for it is serach ability.
When the database is 15000 entrys CCS it gets very much lagging in search speed.
Any remedy for this any optimization to the search facility?
Thank you
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/30/2004, 12:22 PM |
|
In such cases the speed almost always depends on the type of query that you used (related to the type of search ), and the database indexing.
For example if you use wildcard search starting with '%' then the database index cannot be used and the search will be slow.
You will likely not see a better speed if you used the same query and same database in another application, or if you created an application manually. There is just no way to optimize a query if you require wildcard searches.
In your case the optimization could consist of just reviewing your query (Grid Data Source), possibly removing or changing some search criteria that slow it down, and taking a look at your database indexes (outside of CCS).
Many times the database queries can only be optimized by a human, because computer cannot change your decision to perform such a such search.
If you like to post your query here, someone may help you analyze it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
jm
|
| Posted: 08/01/2004, 6:28 AM |
|
Ok I give up
were is the query that the CCS has build so I can remove the % and also please let me know were I can find the query (Grid Data Source)
Thank you
|
|
|
|
peterr
Posts: 5971
|
| Posted: 08/01/2004, 12:22 PM |
|
Please select the grid by clicking on or near its title, then in the "Data Source" property click on [...] to open the Data Source dialog.
Please see:
http://docs.codecharge.com/studio/html/UserGuide/Forms/FormDataSource.html
http://docs.codecharge.com/studio/html/QuickStart/Creat...tWhereProp.html
BTW, I recommend that you go through the tutorial first, as it will help you with the basic use of the program.
Once in the Data Source dialog, you can:
a) change the search parameters so that the search parameter so that it doesn't use the "contains" condition.
b) view your SQL query by selecting Build Query -> SQL, to verify that this is what you need.
OR
c) change Data Source Type from "Table" to "SQL", and then modify or enter the SQL that you need.
As this discussion starts to look like a support thread, I would recommend that you submit a support case at http://support.codecharge.com/.
Thank you.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Anton Hinxman
|
| Posted: 08/03/2004, 12:55 AM |
|
For Java we have 'IronEye SQL' which is all that you need to trace and detect slow SQL submits.
http://www.p6spy.com/download.html
Optimisation of indexes then becomes as easy as looking at the SQL and execute speed and fine tuning your indexes. For MySQL you can even clear the cache to ensure that you have clean results.
For me CCS/Java/MySQL does not have performance problems.
Anton
|
|
|
|
Walter Kempees
|
| Posted: 08/03/2004, 11:50 PM |
|
previous discussion responses, seconded.
No performance problems on behalf of CCS generated code.
Running Apache/PHP/MySQL both on XP(develop) and Linux (various flavours
various platforms.)
MySql known for good performance so do check SQL and Indexes.
Walter
<AntonHinxman@forum.codecharge (Anton Hinxman)> schreef in bericht
news:2410f44fdc2594@news.codecharge.com...
> For Java we have 'IronEye SQL' which is all that you need to trace and
detect
> slow SQL submits.
>
> http://www.p6spy.com/download.html
>
> Optimisation of indexes then becomes as easy as looking at the SQL and
execute
> speed and fine tuning your indexes. For MySQL you can even clear the
cache to
> ensure that you have clean results.
>
> For me CCS/Java/MySQL does not have performance problems.
>
> Anton
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
