• DE
  • EN
  • FAQ
  • Download
  • Contact
  • Login
  • Account
  • Logout
  • Home
  • Functionality
    • The SQL4automation connector
    • Establish a database connection in 2 steps
    • Data management in the past and today
    • Connector & tools
    • Video Tutorial
  • Compatibility
    • Supported controllers
    • Supported databases
    • Supported MES
    • Supported platforms
  • License models
    • Software
    • Software & hardware
    • Download test version
    • Purchase/offer
  • Services
    • Commissioning
    • Consultation
    • Training courses
    • Support
  • References
  • News
  • FAQ
  • Download
  • Contact
  • Login
  • Account
  • Logout
  • DE
  • EN

How long does a database query take?

  • Can I write data to the controller from outside?
  • Why do I need more than one link?
  • How much does it cost?
  • Which databases can be use?
  • Which controllers can be use?
  • How does the demo version work?
  • How do I generate a SQL query in the controller?
  • SQL syntax
  • How long does a database query take?

The duration depends on the controller. PC-based controllers often offer better performance than hardware-based ones. But there are also big differences in hardware-based controllers. Some may take longer to establish the connection, and others to transmit data.

The query takes 20 to 500 ms (or sometimes more) depending on the system and the amount of data.

The performance of the database or the database server has a significant influence on the speed.

A tip: Test your system using the demo license of the Connector to get an indication of the performance of your components.


» find the demo licence here

  • How is the Connector licensed?
  • How to set up a network between controller, Connector and database?
  • Where do I get support?
download test version now

Inasoft Systems GmbH

Bahnhofstrasse 6, CH-3421 Lyssach
+41 34 445 20 10

» info@inasoft.ch

  • Concept & Design: smiroka
  • Programming: suxesiv
  • Data protection
  • Imprint
This website uses cookies to enable certain functions and to improve your user experience. By continuing to browse the site you are agreeing to our use of cookies. More Information OK