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)
This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.
For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.
All data has been migrated (including user logins/passwords) to a new phpBB version.
For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.
Problem with SQL and bot timing out
-
demond
- Revered One
- Posts: 3073
- Joined: Sat Jun 12, 2004 9:58 am
- Location: San Francisco, CA
- Contact:
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
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