Welcome Guest, Not a member yet? Register   Sign In
Very slow insert and update into ci_session
#6

[eluser]Jaketoolson[/eluser]
I see your table is using the InnoDB engine. Have you optimized your table for InnoDB correctly?

For sessions storage, I use the MEMORY (heap) storage engine. It's MUCH faster and perfect for temporary storage.

But again, regardless of the table engine you use, you need to ensure you've optimized your table correctly. I don't mean by running optimize either. I mean by ensuring the settings within your httpd.conf file have been tested and set and you're also not using excessive space through incorrect indexes, column type and lengths...


Messages In This Thread
Very slow insert and update into ci_session - by El Forum - 08-02-2011, 01:05 PM
Very slow insert and update into ci_session - by El Forum - 08-02-2011, 02:30 PM
Very slow insert and update into ci_session - by El Forum - 08-02-2011, 02:36 PM
Very slow insert and update into ci_session - by El Forum - 08-02-2011, 03:30 PM
Very slow insert and update into ci_session - by El Forum - 08-02-2011, 09:19 PM
Very slow insert and update into ci_session - by El Forum - 08-06-2011, 12:17 PM
Very slow insert and update into ci_session - by El Forum - 08-06-2011, 06:09 PM



Theme © iAndrew 2016 - Forum software by © MyBB