UnionOfRAD/lithium — Issue #168: Lithium application working too slow in production
Author: pcnalanda
Created: 2011-10-22 05:01:29+00:00
State: open

I am new in lithium.

I have made an lithium application in production, it's execution is too slow. Even in ab testing (benchmarking) its performance is to bad (16 second per request). And my CakePHP production application taken 0.25 sec per request in ab testing)

I want to make a model to use custom SQL query and wrote code for that as below:

read($sql);
}
}
?>
Above model does not return recordset with tablename key. It return one array having all distinct fields. So we cannot get common filed value from multiple join tables.

We cannot pass update or insert query using Paging::query() function.

Please suggest.