+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: AEXECUTE/AQUERY (/Thread-AEXECUTE-AQUERY)
AEXECUTE/AQUERY - Shaklaban - 10-21-2012 01:07 AM
Has anyone using AEXECUTE/AQUERY on a live shard? As i remember these functions conflicting with EXECUTE/QUERY and crashes the server.
RE: AEXECUTE/AQUERY - Avatar - 11-04-2012 11:58 PM
(10-21-2012 01:07 AM)Shaklaban Wrote: Has anyone using AEXECUTE/AQUERY on a live shard? As i remember these functions conflicting with EXECUTE/QUERY and crashes the server.
Yes, i'm using those mysql stuff. The logic is a little bit different since in db query, request is done at the moment once command is just executed but aquery is actually first getting the functions and you can do some stuff until db just execute query. The important point in aquery different than query is just responding time and it is usefull in order not to crash server with overloading mysql tasks. First do some task in sphere server, like not selecting db and executing at the same time , just you can do it afterwards.
Also, it is vital that you shoud not use query or aquery while db connected at the same time, you should first stop aquery or query to pass another function, otherwise server will crash.