Post by kestas » Wed Sep 27, 2017 8:54 pm

My opinion it is bad!

Working together with author of this module https://www.opencart.com/index.php?rout ... n_id=17618 we find out the problem appear in the new release OC3.x.x that sessions data was moved to the database. DB table where sessions are stored has no space to fit all session's data (both lists of terminals and pakomats!) when omniva & lpexpress both enabled. In previous versions of the OC session's data was stored to the file.
there is some ways to solve this issue
1. switch sessions to file engine in system/config/catalog.php
2. change type of column of table where session data stored
or maybe authors of the OC 3.0 can suggest better way?

Thank you in advance...

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by kestas » Thu Sep 28, 2017 3:42 am

anybody knows why sessions data was moved to db where not enough space for this data?

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by straightlight » Thu Sep 28, 2017 10:24 am

Moving the session string into the database does has its good but also has its bad. Access to the database is required in order to initiate a more secured session for the users. Although, even though this tactic may have been used for security purposes, it may not only slow down performance a bit but also limiting the capacity size whenever new session strings are being generated even though when the expiry time period has exceeded for each rows since either more users or search engine bots may visit the site frequently and the session table may not be able to handle as many data in order to maintain the site's performance.

Switching back to file mode may greatly help the store's performance. Although, it is a less secured strategy when users visits the store.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by phinq1910 » Thu Sep 28, 2017 11:30 am

I think it is better (can't be hijacked)

User avatar
New member

Posts

Joined
Sat Jun 11, 2016 11:43 am
Location - Hanoi

Post by kestas » Thu Sep 28, 2017 4:15 pm

phinq1910 wrote:
Thu Sep 28, 2017 11:30 am
I think it is better (can't be hijacked)
Ok, but how increase capacity for the session data and performance?

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by straightlight » Thu Sep 28, 2017 7:03 pm

By upgrading server capacity plans.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by kestas » Fri Sep 29, 2017 3:31 am

...I find out simplest solution. I have changed session's data column type from text to longtext. Thats all, now working fine. Enough space for session data...
So maybe it is good to move session's data to DB. :) Only need to do some steps to get it working properly.

Thank's all for help and Good Luck

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by straightlight » Fri Sep 29, 2017 3:34 am

Extending the field size is only a temporary solution, however.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by kestas » Fri Sep 29, 2017 4:04 am

straightlight wrote:
Fri Sep 29, 2017 3:34 am
Extending the field size is only a temporary solution, however.
If is true what you told, it is not good for beginners who starting with now money and use cheap servers for that.. they simply goes away from OC... and not only beginners, all will think about it if OC stops to work without understandable reason... I hope developers of the OC find some better solution for example maybe to have two possibilities to use DB or files for sessions data... And will keep users... :)

Cheers

Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by straightlight » Fri Sep 29, 2017 4:18 am

If is true what you told, it is not good for beginners who starting with now money and use cheap servers for that.. they simply goes away from OC... and not only beginners, all will think about it if OC stops to work without understandable reason... I hope developers of the OC find some better solution for example maybe to have two possibilities to use DB or files for sessions data... And will keep users...
One of the advantage for all this is especially the fact that Opencart is free! :)

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by al404 » Wed Dec 19, 2018 6:57 pm

Just found this topic since we developed a new e-commerce with OC3 and journal, already user for other projects
After activating a social camping the website got slower and slower and could not understand why, cache are enabled and is the same configuration that we had on other project

Just found oc_session with 24k records, running an optimized on DB tables got back speed to the website

Where is set lifetime of oc_session session? How can I increase performance?

New member

Posts

Joined
Fri May 04, 2012 4:29 pm

Post by ADD Creative » Wed Dec 19, 2018 8:49 pm


www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by nongetjie » Fri Dec 28, 2018 8:01 pm

al404 wrote:
Wed Dec 19, 2018 6:57 pm
Just found this topic since we developed a new e-commerce with OC3 and journal, already user for other projects
After activating a social camping the website got slower and slower and could not understand why, cache are enabled and is the same configuration that we had on other project

Just found oc_session with 24k records, running an optimized on DB tables got back speed to the website

Where is set lifetime of oc_session session? How can I increase performance?
I'm experiencing the exact same problems. Did you manage to solve this?

New member

Posts

Joined
Wed Nov 07, 2012 8:28 pm

Post by al404 » Mon Feb 18, 2019 8:32 pm

the only way I found is to run an optimize on tables every once in a while :(

New member

Posts

Joined
Fri May 04, 2012 4:29 pm
Who is online

Users browsing this forum: No registered users and 39 guests