Threaded Mode | Linear Mode

***Coruja*** · 01-26-2015 03:09 AM

probably your function is making the server unstable because you're executing too much SQL commands
everytime you execute a SQL command, sphere will freeze until the SQL server return back the SQL response to sphere. On lightweight SQL functions, you won't notice any freeze because it will execute the function in just 0.1s. But if you execute 100x this same SQL command on loop, the total execution time will be increase to 10s (100 x 0.1s) and this will freeze sphere for about 10 seconds until all SQL commands got executed

so unfortunately to fix this you must rewrite your code to make it use less SQL commands

also you can optimize a lot this passable function, reducing 48478647864763874 lines to just a few lines
instead check for every single value, you can check an entire value range on just a single line

this:

Code:

[function passable]

if <argv0>==3

        return 1

elseif <argv0>==4

        return 1

elseif <argv0>==5

        return 1

elseif <argv0>==6

        return 1

elseif <argv0>==7

        return 1

elseif <argv0>==8

        return 1

elseif <argv0>==9

        return 1

elseif <argv0>==10

        return 1

elseif <argv0>==11

        return 1

elseif <argv0>==12

        return 1

elseif <argv0>==13

        return 1

elseif <argv0>==14

        return 1

elseif <argv0>==15

        return 1

elseif <argv0>==16

        return 1

elseif <argv0>==17

        return 1

elseif <argv0>==18

        return 1

elseif <argv0>==19

        return 1

elseif <argv0>==20

        return 1

elseif <argv0>==21

        return 1

elseif <argv0>==22

        return 1

elseif <argv0>==23

        return 1

elseif <argv0>==24

        return 1

elseif <argv0>==25

        return 1

elseif <argv0>==51

        return 1

elseif <argv0>==52

        return 1

elseif <argv0>==53

        return 1

elseif <argv0>==54

        return 1

elseif <argv0>==55

        return 1

elseif <argv0>==56

        return 1

elseif <argv0>==57

        return 1

elseif <argv0>==58

        return 1

elseif <argv0>==59

        return 1

elseif <argv0>==60

        return 1

elseif <argv0>==61

        return 1

elseif <argv0>==62

        return 1

...

can be reduced to:

Code:

[function passable]

if (<argv0> >= 3) && (<argv0> <= 25)

        return 1

elseif (<argv0> >= 51) && (<argv0> <= 62)

        return 1

...

Threaded Mode \| Linear Mode Sever goes unstable and crashes
Author	Message