Outliner Software Forum RSS Feed Forum Posts Feed

Subscribe by Email

CRIMP Defined

 

Tip Jar

Scrivener for Windows versus Writing outliner add-in for MS Word

View this topic | Back to topic list

Posted by Alexander Deliyannis
Nov 13, 2011 at 11:09 AM

 

JBfrom wrote:
>However, given
>the slowness of my previous experience with sql databases, I’d want to hear reports of
>users successfully operating databases much larger than 5gb. For example, one of my
>ebooks folders is 60gb.

I will point to Richard’s answer here http://www.outlinersoftware.com/messages/viewm/11337 to describe my own approach for such material too. I really cannot imagine why one should want to keep a collection of PDFs within a single huge database file. The file itself would become fragmented and slow, it would be a nightmare to backup regularly, and would invite corruption in the event of the first problematic system shutdown.

Re slowness, the client-server architecture inherent in SQL databases may indeed be slower than directly accessing a huge text file, but I’m not sure how the two are comparable in terms of content flexibility. Or am I missing something?

In any case, you may want to take this discussion to the said topic http://www.outlinersoftware.com/topics/viewt/3047 as more relevant.