CI with Ajax is too slow ???

[eluser]Unknown[/eluser]
thank for your reply,

the time is given with a server on internet, I was 155ms for PDO and 475ms for CI.
And My little test is on local, 22ms PDO and 130 CI

Good point for asynchronous Ajax, but this is just an example for my test.

The query for the test is not complicated:

Code:

SELECT date_cnx, address, information FROM connection WHERE userid = 112 ORDER BY DESC LIMIT 10 date_cnx

I have indexes on all tables and I have little data in my tables

I use only Query Bindings:

Code:

$ sql = "SELECT * FROM WHERE id = some_table AND status = AND author =??"
$ this-> db-> query ($ sql, array (3, 'live', 'Rick'));

and it may be slower than:

Code:

$ this-> db-> query ("SELECT * FROM some_table WHERE id = 3 AND status = 'live' AND author = 'Rick'");

For cache management, great idea, I found the documentation, I try this
http://ellislab.com/codeigniter/user-gui...ching.html

see you soon for results