Martyn Houghton Posted May 25, 2021 Posted May 25, 2021 We are attempting to do some date matching and need to export all our records from h_sys_contact as we provide external customer support. We are hitting the limit of 20,000 records as we have 28,890 current records which is growing daily. Is there a setting to control the record limit or is this hard coded? Cheers Martyn
NeilWJ Posted May 26, 2021 Posted May 26, 2021 Hi @Martyn Houghton, I believe it is hardcoded as a max. There is also a 30 second execution limit as well i believe. What i would suggest is run several queries with limit clause. So something like 1. select * from thetable order by primaycolumn asc limit 0 , 5000 - then export 2. select * from thetable order by primaycolumn asc limit 5000, 10000 - then export 3. select * from thetable order by primaycolumn asc limit 10000, 15000 - then export 4. select * from thetable order by primaycolumn asc limit 15000, 20000 - then export5. select * from thetable order by primaycolumn asc limit 20000, 25000 - then export 6. select * from thetable order by primaycolumn asc limit 25000, 30000 - then export Know its a pain but think that is only feasible way using the UI. Alternative is you raise a request with support/cloud/account manager to get your data exported.
Martyn Houghton Posted May 27, 2021 Author Posted May 27, 2021 @NeilWJ Thanks for confirming. We will look at batching the output. Cheers Martyn
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now