session lock feedback |
hi everyone
i want to give feedback when query takes long and user session locked, i mean like "you should wait until query ends" i have tried but no results for me i have get_lock function in those pages
i guess "SELECT GET_LOCK('".$arg."', 300) AS ci_session_lock")->row()->ci_session_lock" is locked my session but i did comment that line nothing is affected thanks for suggestions
Hey,
I'am not shure I do understand your questen correct. But the documentation mention's that they use session for the following reason : "non-blocking requests in the context of sessions also means unsafe, because modifications to session data (or session ID regeneration) in one request can interfere with the execution of a second, concurrent request. This detail was at the root of many issues and the main reason why CodeIgniter 3.0 has a completely re-written Session library." Source : https://codeigniter.com/userguide3/libra...oncurrency (03-19-2019, 03:33 AM)wjonker Wrote: Hey, thanks for reply but i read documents and i know why ci use get_lock, so it wont solve my problem i just want to give feedback to users when session locks. for example query takes time about 5 minutes and user click another request, i want to give feedback like "the last request is running, you should wait for this" (03-20-2019, 06:57 AM)php_rocs Wrote: @makif,user search about a year query and many conditions it takes a little bit long and also i use exit in get_lock function on mysql database_driver page but not working, it turned query to me :/ how can i learn when session lockes |
Welcome Guest, Not a member yet? Register Sign In |