Database Direct - Record Limit 20,000

[Martyn Houghton]

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]

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.

[Martyn Houghton]

@NeilWJ

Thanks for confirming. We will look at batching the output.

Cheers

Martyn