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
Solved! Go to 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.
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.
Thanks Carles Coll, Traditional RDS is the best option for me.
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.
Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.