Jump to content
UBot Underground

MYSQL Timeout for v4


Recommended Posts

Hi.  My mysql bots work great in V4, unless the query takes a long time.  Unlike navigation and other nodes, the query DB doesn't allow us to specify timeout.

 

Essentially, as far as I can see it seems impossible to work with large tables that require more than 30 seconds to return results.

 

The queries work fine in MYSQL workbench, typically taking about 32 seconds.

 

 

The query:

select site_id,network_id,wp_link,updated_at,id,author_member_id from posts where content like '%<a href="http://google.co.uk%' limit 2000;

Yes it's an ugly query but that's what I have to work with for now.

post-1851-0-88233800-1406022019_thumb.jpg

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...