egghelp/eggheads community

Problem with SQL and bot timing out

2004-11-15T18:19:32-04:00

the Thread package is not a built-in, neither with 8.1 nor with 8.4; you have to obtain it separately (check out sourceforge's tcl project), compile and install it under your tcl distribution

Statistics: Posted by demond — Mon Nov 15, 2004 6:19 pm

Problem with SQL and bot timing out

2004-11-15T16:30:17-04:00

I know the database could be better arranged, but currently i don't have a choice....

What is the difference between tcl81-threads and the tcl84 package?

Statistics: Posted by -W0kk3L- — Mon Nov 15, 2004 4:30 pm

Problem with SQL and bot timing out

2004-11-15T15:16:30-04:00

the proper way to fix this is to fix your database/queries - it shouldn't take 3 minutes to fetch data, never; use proper table indexing and refer to mysql docs on how to optimize that stuff

as last resort you can use the Thread package and rewrite your script to execute db queries in a separate thread, while allowing all normal processing to go on; however, you will need to recompile your TCL libs with --enable-threads

Statistics: Posted by demond — Mon Nov 15, 2004 3:16 pm

Problem with SQL and bot timing out

2004-11-15T13:45:27-04:00

Hi, i have a little problem....

I've created a script, which can be triggered from within a channel. It does a query on mysql, and dumps the results back to the channel where it was requested. The problem is that it can take up to 3 mins before mysql output the results. Meanwhile the eggdrop times out and restarts (on Quakenet).

Is there a way to fix this? I can't make the query go faster (large database), so is there a way to let the tcl standby until the query is done? (so other commands can be used in the meantime).

(I use Eggdrop v1.6.17 with mysql.mod compiled)

Statistics: Posted by -W0kk3L- — Mon Nov 15, 2004 1:45 pm