How to set variables using database and table? Seems clunky

[mdc101 15]

Hi Guys so I have been playing around with the database command and setting variables from the retrieved dataset.

 

I created a command that calls a single record and put it in the table. It then takes the 19 columns from the table and sets each one as a variable to use.

 

This process takes 1 minute 23 seconds to do.

The call to the mysql database is a view and via the query editor it takes 0.003s.

 

Does this seem right?

Query editor 0.003s ubot to complete task 1m 23s

I think this is a very slow way of doing things.

 

Is there a faster way of setting the variables?

 

Even the debugger is running slow.

I'm on win 8, ubot 5 latest version, dev

 

Am I doing this correct?

 

Can anyone suggest a faster method of doing this with examples?

 

Thanks

 

Matt

 

sample.txt

[mdc101 15]

Oh forgot to say this is running on my local machine which is pretty fast and there is only 7 rows in table

[blumi40 222]

i thing it has to do with the mysql query
 

parameters.dfy_id,

parameters.date_due,

parameters.date_created

will be faster if u index  those columns  in your mysql table

 

and on your UPDATE sql u dont need "user_projects.client_name" if your dfy_id  is a key-id

[mdc101 15]

Thanks B for the advise I will try this.

[mdc101 15]

The indexes and changes suggested shaved of 10 seconds, thanks for the tip

[mdc101 15]

I figured out why things where running so slow.

The logging was on and as soon as i turned logging off the bot flew as expected.

Thanks blumi for the pointers earlier