¿ªÔÆÌåÓý

Database and file number limits


 

Hello

I'm investigating ways of making old mails available on Groups.io.

I thought that I found a perfect solution (database) until I discovered that no more than about 5000 rows get imported. Is this a per database limit? I have groups with over 100 000 messages, so if that is the limit, it would take 20 databases (and users searching the archives would have to search in 20 different places).

Searching mails in a database is nice because you can see a "preview" of the posts after you've done a search, and therefore use your browser's find function to find what you're looking for much quicker.

Another way to make old mails available on Groups.io is by uploading them as individual e-mail files (in e.g. HTML format) to the Files section. I have discovered that it is unreliable to try to upload more than about 2000 files at a time, but it doesn't matter in the Files section because a file search searches all folders automatically. Then it's just a matter of explaining to users that they need to install a browser extension that allows them to read the mails in the browser.

But... is there a file number limit?

One downside of using the Files method for making old mails available is that if you want to be able to search within specific folders, you have to create dummy subgroups and use each subgroup's Files section for each group of messages (because a group's file search always searches all files, even if you navigate to a subfolder).

To summarise: is there a row limit on databases, and is there a file number limit on files?

Thanks
Samuel


 

On Sat, Jan 4, 2020 at 08:52 AM, Samuel Murray wrote:
To summarise: is there a row limit on databases, and is there a file number limit on files?
There's not a hard limit on db rows, see /g/GroupManagersForum/topic/38188093

I'm not aware of a limit on the number of files.

Duane
--
GMF's Wiki: /g/GroupManagersForum/wiki
Help: /static/help
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions