Transitioning Your Application

To transition your application, simply change the connection credentials to point to SingleStore Helios.

One thing to keep in mind is Code Generation. Code generation makes loading a schema into SingleStore Helios for the first time is slower than with MySQL. The first time SingleStore Helios encounters a table schema, it generates and compiles code that implements infrastructure around the table (memory allocation, inserts, deletes, iterations, etc.). Once a table is compiled, SingleStore Helios will be able to reuse it for the lifetime of your application — even if you restart the server or drop (and recreate) the table. The INSERT queries generated by mysqldump also have to be compiled exactly once.

When transitioning your application:

  • Queries that throw errors most likely correspond to unsupported syntax (see SQL Reference for supported SQL surface area).

Last modified: November 29, 2022

Was this article helpful?