CODEWITHSUNDEEP
mysqlsql
Markus
Markus

Reputation: 4242

Cheapest SQL Statement possible / Are there Client-Side SQL Statements?

Questions

  1. What is/are the most cheapest SQL-Statment(s) (in terms of Processing Overhead/CPU Cycles).
  2. Are there (this will most likely be DB-Client specific) any Statments that are evaluated directly by the client and even do not go to the database server?

The result doesn't matter, if an empty statement (which produces an SQL Error) is the cheapest OK, then this is good too. But I am more interested in non Error Responses.

Background:

I have an application that queries a lot of data from the DB. However I do not require this data. Sadly, I have no possibility to skip this query. But I have the possibility to change the SQL Query itself. So I am trying to find the cheapst SQL Statement to use, ideally it should not even go to the SQL Server and the SQL-Client Library should answer it. I will be using MySQL.

UPDATES (on comments):

Yes, it can be a No-Operation. It must be something I can pass as a regular SQL String to the mysql client library. Whatever that string could be, is the question. The goal is, that this Query then somehowreturns nothing, using the least Resources on the SQL Server as possible. But in idealcase the client itself will realize that this query doesnt even have to go to the server, like a version Check of the client library (OK I know this is no standard SQL then but maybe there is something I do not know about, a statement that will be "short circuited/answered" on the client itself).

Thanks very much!

Upvotes: 0

Views: 432

Answers (1)

Anthony
Anthony

Reputation: 37065

DO 0

DO executes the expressions but does not return any results. In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result.

Upvotes: 3

Related Questions