# 10,000 line restriction
**URL:** https://pug.phocassoftware.com/t/10-000-line-restriction/607
**Category:** Ask the Community
**Created:** [May 23, 2018, 11:33am UTC](https://pug.phocassoftware.com/t/10-000-line-restriction/607 "2018-05-23T11:33:08Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@LaneyPhocasLubes](https://pug.phocassoftware.com/u/LaneyPhocasLubes)
#### Post date: [May 23, 2018, 11:33am UTC](https://pug.phocassoftware.com/t/10-000-line-restriction/607/1 "2018-05-23T11:33:08Z")
Hello, does anyone know how to remove the restricted transaction count of 10,000 lines in a download from Phocas.
I’m not looking to do this system wide but just allow one or two user this access.
Thanks
Graham
---
### Author:  [@anon41607707](https://pug.phocassoftware.com/u/anon41607707)
#### Post date: [May 23, 2018, 12:49pm UTC](https://pug.phocassoftware.com/t/10-000-line-restriction/607/2 "2018-05-23T12:49:11Z")
Hi Graham,
Yes this can be done. There is a need to make you aware that this restriction is there to avoid a number of large queries being run concurrently, which could impact overall speed of the site. That said, an administrator should be able add a setting to each user, with a specific value to apply.
- Within the users section of the website, select a specific user.
- Go to the Settings tab of that user
- Choose ‘New’
- Within the dialog box that appears enter ‘TranCount’ as the name (without quotes)
- Enter a value to apply.
- Click Save.
I’ve just written this from memory, so please let me know if this doesn’t work. Again though I have to stress the impact this can have if every user has the ability to run very large queries.
Regards,
Lee
---
### Author:  [@LaneyPhocasLubes](https://pug.phocassoftware.com/u/LaneyPhocasLubes)
#### Post date: [May 23, 2018, 1:13pm UTC](https://pug.phocassoftware.com/t/10-000-line-restriction/607/3 "2018-05-23T13:13:25Z")
Excellent news, thanks Lee.
I understand the implications and will only add this setting to 1 or 2 trusted users. However it looks like I don’t have access to the user settings tab, even though I’m the Phocas admin at my organisation.
I’ll contact Nejah to see if he’ll allow me access to ‘settings’.
Thanks
Graham
---
### Author:  [@KellyS](https://pug.phocassoftware.com/u/KellyS)
#### Post date: [September 22, 2020, 2:46pm UTC](https://pug.phocassoftware.com/t/10-000-line-restriction/607/4 "2020-09-22T14:46:07Z")
Hello Lee. Thank you for your post! I too need to remove the 10,000 row limit for a specific user and specific database, but am having trouble finding the “Settings tab for a user”. Could you direct me to that? Thanks in advance! Regards, Kelly Sturm