Query Performance using scripting

Ignition
1

Hey everyone, quick question,
I basically want to know if there is a big difference between running the query the following two ways:

1:
query = "INSERT INTO orders (account_id, product_name) VALUES (?, ?)"
args=[123,"Bananas"]
system.db.runPrepUpdate(query, args)
2:
system.db.runPrepUpdate("INSERT INTO orders (account_id, product_name) VALUES (?, ?)", [123,"Bananas"])

It's probably the correct and logical way to go with #1 since it will also keep the code clean and organized, but I figured I ask and see if someone knows if there is really a performance difference between the two especially when it comes to larger queries and larger scripts.

Thanks :nerd::+1:

2

There will be essentially zero difference - go with whatever is easiest to maintain (in my opinion, separating the query and arguments).

2 Likes