cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

QueryDataTableEntries service fetch result slow.

SOLVED
Highlighted
Newbie

QueryDataTableEntries service fetch result slow.

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

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: QueryDataTableEntries service fetch result slow.

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.

View solution in original post

3 REPLIES 3

Re: QueryDataTableEntries service fetch result slow.

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.

View solution in original post

Re: QueryDataTableEntries service fetch result slow.

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.

Re: QueryDataTableEntries service fetch result slow.

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