Am I saturating my database? [closed]

0

Currently I have running 3 (three) desktop applications which consult 1 (one) time per minute a database to know if there are new features in it. The database is hosted in a website hosting (I have the DB of the website itself and another DB for this purpose)

The database engine is MySQL

My question is, will I be saturating the DB with 3 queries per minute? (It's just a SELECT). What other alternative do I have to polling to know if there are new features in the database?

    
asked by Federico 27.06.2018 в 18:35
source

1 answer

1
  

My question is, will I be saturating the DB with 3 queries per minute?

The answer is:

NO

Three queries per minute to MySQL is a joke, a walk in the park, a bread with butter. The databases are designed to process a much larger number of requests.

Now, do not be fooled by what I just said. You only mention that you make a SELECT and this makes it look like a relatively simple query. There are some things to keep in mind, such as:

  • How many records does the table have? Is it indexed?
  • How complex is the query ?, do you do some JOIN s?
  • When are you doing the consultation, it takes a long time to get an answer?

If it's a simple query in a relatively small table (a few thousand records), then you have nothing to worry about and you do not need to complicate your life with other things. Keep using polling.

    
answered by 27.06.2018 / 23:35
source