QueryDataTableEntries service fetch result slow.

[magrawal]

Hi guys,

In my application I've used QueryDataTableEntries service at many places but the problem I am facing with this service is that when I defined it's maxItems to 100000, it is fetching results very slow.

is anyone faced the same issue? how could I optimize response time here?

Thanks,

Meenakshi

[CarlesColl · Accepted solution]

Hi,

Here you have an interesting read: https://community.thingworx.com/community/developers/blog/2016/03/11/where-should-i-store-my-thingwo...

But by the way, if you have DataTables larger than 100k registers, better you go and move those to a real traditional relational database. For instance if you have Postgres TW you can create a table and connect to it through Database Thing, then you will be able to query through traditional SQL.

Carles.

[magrawal]

Thanks Carles Coll​, Traditional RDS is the best option for me.

[supandey]

Hi Meenakshi, expanding on what Carles already mentioned, indeed it will help you address your concerns - have a look at this JDBC Extensibility and JDBC Connector Extension from ThingWorx Marketplace.

Hope this helps.