jpser
Posts: 44
|
| Posted: 01/12/2006, 6:06 AM |
|
Context: W2k Apache 2 PHP5 (SCSI Disk, 512 Mo)
Mysql 5 Innodb
Our databases from 100 Mo to 5 Go
It seems impossible to fasten a simple report
with Stats by product ( Average Price, Sum Qty,...)
Apache responds time too long ( after 45 sec)
I tried optimize with limit, and so on..
Is there an improvement expected
The same with access goes very speed
Thanks for answer.
JP from France 
_________________
jp serei
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 01/12/2006, 7:18 AM |
|
jpser
What does your query look like??? Have your tested your query to see if it is optimized??? Have you tested your code for bottle necks??? Are you using indexed fields in your query???
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/12/2006, 11:01 AM |
|
jpser,
This doesn't seem to be related to CCS or report writer.
You have to look for problem in your database or query, not in CCS or report writer. It is your responsibility to create proper database indexes. The report simply retrieves and displays the data from the database and cannot be faster than your database itself.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Benjamin Krajmalnik
|
| Posted: 01/15/2006, 1:14 PM |
|
As Peter mentioned, proper database design is critical for speed.
Non-CCS related feedback - in a certai application which we use (SQL Server
backend), purging records was taking over 1 second per item (which of course
contains many related tables). Modifying the schema by adding the correct
indices changed that to over 200 per second. In our case, we needed to
delete over 240K records (with their related records!) so the original
schema was unworkable.
|
|
|
|
|
