[RESOLVED] Is prepare statements the prefer choice?

[ifubad]

Is the use of prepare statements just good practice even when performing a single simple query?

[NogDog]

If no values are being passed from the application to the query (i.e., there are no parameters to bind), then it's probably a bit more efficient to just use a straight query. However, we're probably talking milliseconds difference (or more likely microseconds), so it's not something to lose sleep over in most situations.

[ifubad]

Thnx for the explanation, NogDog.

[Weedpacket]

Certainly there is no benefit to using prepared statements sometimes and straight queries other times. It's easier to be consistent - one less decision to have to keep making.