Jump to content

Database Direct - Record Limit 20,000


Recommended Posts

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

Link to comment
Share on other sites

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 export


5. 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.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...