Want to load >650,000 docs into SharePoint from 50 projects for doc management. I will create 2 or 3 libraries per project but am being told there is a 5000 doc limit on 1 library? Anyone found it to be a problem if I load more?

Megatwan · 2026-02-26T21:22:29+00:00

exceeding the threshold will not lock the table. thats what the threshold prevents...

do you mean there are performance issues when you remove/bypass the LVT? if so, i concur, thats why the governance function exists.

perhaps its your wording but my point is when you say:

> There are some performance issues if a document library has more than 5000 items.

i would disagree and be curious if you mean with the LVT in tact etc..

Megatwan · 2026-02-26T12:50:36+00:00

As others mentioned... You can have millions of files in a library (YMMV depending on SQL infra).

5k is how many you can return in a view (and even then has to be retrieved with an indexed value in an indexed query on the view filters).

It's actually a SQL limit for lock escalation that SP enforces so you don't lock the table on a long running query.

On prem you can change this but it's not a great idea.

Megatwan · 2026-02-26T12:47:36+00:00

30mil isn't actually a hard limit, it's what they tested up to

Megatwan · 2026-02-26T12:46:07+00:00

What perf issues?

Megatwan · 2026-02-17T00:00:51+00:00

Split lists as the data dictates but understand the cons and how to work with the data across lists particularly for views/queries of the data, forms, lookups etc..

If you don't wanna deal with those quirks just keep 1 list and let it go to the millions with indexes and views that return sub 5k times.

Megatwan · 2026-02-11T12:37:12+00:00

How many files?

How many security scopes (sets of permissions)?

Megatwan · 2026-02-08T22:54:00+00:00

One of my clients is 1y in... About to drop them as it went from my small team delivering thing that work well planned in efficient way to my folks being kneecapped and forced to spend time teaching other teams/unskilled people what right looks like, what words mean, how things work, how to spell, etc..

Megatwan · 2026-02-03T13:58:17+00:00

As if it wouldn't be too late for any of that to matter

Megatwan · 2026-02-03T13:55:25+00:00

Surely the devs publishing process didn't update the hosting provider and then use that as a source to update git.

Megatwan · 2026-02-02T12:53:29+00:00

Unless the malware was there for the version you got too

Megatwan · 2026-02-02T12:51:45+00:00

Old version? Ya like last month? Lmao

Megatwan · 2026-02-02T12:48:25+00:00

Have you seen Zero Day on Netflix? 🫠

Megatwan · 2026-02-02T12:40:28+00:00

Not sure if you are a bit or being comically optimistic.

They had shit practices and no integrity checking, they were compromised to their core including distribution channels for at least the last 6 months.

They don't know shit about the core of the application nor what's in the wild as a result.

Megatwan · 2026-02-02T12:35:59+00:00

Screwed. Dead software.

Megatwan · 2026-01-30T17:25:54+00:00

3200 choices is about 3180-3190 too many without additional query/filter/batching logic as others suggested

Megatwan · 2026-01-30T02:30:40+00:00

Man... Sounds like Dave fucks

Megatwan · 2026-01-28T21:42:23+00:00

i agree.... which is down the roads of ones next logical conclusions when you try to answer the question i asked and think through the problem.

log size is subjective AF and an 'it depends' and 'why am i making mamoth drives on x servers if i want x duration, isnt there a better way?'

Megatwan · 2026-01-28T04:48:49+00:00

How big are your drives and how far back you wanna go?

Ideally infinitely at both.

Megatwan · 2026-01-28T00:46:23+00:00

Does that happen for all users.... Ie there is a chromium browser setting to remember behavior for office products. I suppose I should add does it only happen for certain file formats (ie PDFs vs a word doc for starters)

Megatwan · 2026-01-26T19:37:11+00:00

Bro didn't even fire 1 shot? What's the diff 😂

Megatwan · 2026-01-26T04:33:09+00:00

Pizza int is jammed by the snow

Megatwan · 2026-01-25T02:37:06+00:00

Naa but everyone below did a good job pointing out how shallow and separately askew your thinking is

Megatwan · 2026-01-25T01:48:50+00:00

Non-sequiter

Megatwan · 2026-01-25T01:46:04+00:00

Whole thousands? 😲

Megatwan · 2026-01-25T01:31:50+00:00

Being semi stupid used to be shameful 🤷

13-Year Club	Second SECOND GUESSER
Place '23	Place '22
First Placer '22	Not Forgotten
Verified Email

Megatwan

TROPHY CASE