# Error with executeQuery()

**URL:** <https://forum.inductiveautomation.com/t/error-with-executequery/75954>\
**Category:** Ignition\
**Tags:** ignition81, perspective, database\
**Created:** [July 5, 2023, 6:00pm UTC](https://forum.inductiveautomation.com/t/error-with-executequery/75954 "2023-07-05T18:00:01Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 5, 2023, 6:52pm UTC](https://forum.inductiveautomation.com/t/error-with-executequery/75954/8 "2023-07-05T18:52:05Z")

</div>

> [@ian.sebryk](#):
>
> how to import 10000 records QUICKLY

See this topic for one technique:

> [@Using Gateway scripts to move data from one database to another](https://forum.inductiveautomation.com/t/using-gateway-scripts-to-move-data-from-one-database-to-another/75953/5):
>
> This, handed to system.db.runPrepUpdate(), will insert three rows at once: INSERT INTO some\_table (some\_column1, some\_column2, some\_column3) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?) You would provide the nine arguments in a flat list. You would construct the SQL dynamically with the right number of inserted row placeholders and the right number of JDBC substitution arguments. Just be careful not to exceed the limit on ? placeholders. Some JDBC drivers choke at around 2000.

---

_[View the full topic](https://forum.inductiveautomation.com/t/error-with-executequery/75954)._