Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
ESdat Online - Chem table data limit exceedance - Chem Table query requiring more than 40,000 results
Options
Go to last post Go to first unread
Previous Topic Next Topic
Mat J  
#1 Posted : Wednesday, February 17, 2021 1:10:26 PM(UTC)
Mat J
Rank: Member

Reputation:

Groups: Registered
Posts: 5

Hey Team,

I am in the process of exporting chem tables from ESdat online, and have run into the issue that the results I require are greater than the 40,000 limit. 

I have refined the search through filters, and this is still an issue. The data is only present in ESdat Online (not desktop), I mention this as I believe this isnt an issue on the dektop version?

I would prefer not having to batch export and join tables if possible. Any tips?
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Friday, February 19, 2021 6:14:58 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Mat,

That is correct, it is due to constraints on web servers, the only immediate resoution is to filter for, for example for just PAH's and export those, then produce a seperate table for Metals.  Seperate tables by Suite would likely be needed for printing or producing PDF's for that volume of data, if that is the end need.

For higher spec servers it may be possible to increase that 40,000 limit and diagnostics to determine that were included in the recent update to V4 of ESdat Server and ESdat Online.

Regards,

Warwick

Edited by user Friday, February 19, 2021 6:15:34 AM(UTC)  | Reason: Not specified
Back to top
WWW
Mat J  
#3 Posted : Friday, February 19, 2021 9:41:56 AM(UTC)
Mat J
Rank: Member

Reputation:

Groups: Registered
Posts: 5

Hey Warwick, 

Thank you for your reply. Yeah, I have been going in circles trying to figure out the best way for split exports, so cheers for the tip re suites. The tricky part is paring these exports with environmental standards, and confidently knowing that all results have been captured.

I was aware of the upgrade allowing for more than 40,000 and had hoped our database would qualify for it, however it seems that this may not be the case. In fairness to ESdat, it is a ridulous amount of results to be in a table, but unfortunately, the project reporting requires it.
Back to top
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET