Customer section

Forum index » X-SQLT » Import to Database (slow)

Anonym


Response

Posted: 19.07.2019 [06:50]

Hi
I am testing and the export of data is very quick, but the insert of data seems to be very slow as it is doing.
I am connecting to mysql via ODBC and it is importing around 14 records per second
Is this normal? I believe it might be as I don't know if X-SQLT do bulk inserts (https://www.www.geeksengine.com/database/dat...

Code:


<?xml version="1.0" encoding="utf-8"?>
<xsqlt name="Import data to database">
<description>
Import data to database
</description>
<parameters>
<!--
<source-custno kind="float" />
<source-taxrate kind="float" />
-->
</parameters>
<script>
<source kind="file">
MYDATA.xml
</source>
<xsql kind="inline">
<insert>
insert into
ssi.keyfigurevalues(
created, timeframe, keyfigureconfiguration_id, value)
values(
current_timestamp,current_timestamp,:source$keyfigureconfiguration_id, :source$value)
</insert>
</xsql>

<transform kind="xml" record-tag="MYDATA"></transform>


<destination kind="oledb">
<connection-string>
DRIVER={MySQL ODBC 8.0 Unicode Driver}; SERVER=SERVERIP; PORT=3306; DATABASE=world; UID=USER; PASSWORD=PASS;OPTION=3;
</connection-string>
</destination>
</script>

</xsqlt>

[./code/]

New post to this topic

[.bold.]TEXT[./bold.]  [.italic.]TEXT[./italic.]  [.code.] TEXT [./code.]  [.quote.] TEXT [./quote.]

Number of topics: 373 • Number of posts: 1244 • Number of registered users: 62

Copyright © 2008-2021  Precision software & consulting. All rights reserved.
Send your comments to www pages.
Contact   |   RSS
Precision software & consulting
Narodnich mucedniku 447
738 01  Frydek-Mistek
Czech Republic