Re: [Treebase-devel] Disk space for treebase production database

[Hilmar L. <hl...@ne...>]

On Aug 5, 2010, at 2:44 AM, William Piel wrote:

> Is the anticipated slowness in the time it takes to upload files to  
> a directory for parsing, and not the time it takes to insert records  
> once the file is parsed? Or is the anticipated slowness for both of  
> these steps?

It might be both, though the first step would be independent of the  
size of the database, and thus I'd expect the main problem to be the  
second step.

> Do we need to wait for something to be built on dev before we can do  
> the tests, or is it enough to test:
>
> http://treebase-dev.nescent.org/treebase-web/


I understood from Jon that this is a small database with much fewer  
records than the production one. I would expect the primary source of  
performance degradation, if there is one, to come from updating large  
indexes, which, if done record by record that is inserted (and there  
is hardly an alternative way if the database is online for concurrent  
querying), is highly I/O intensive, and the more so the larger the  
index is.

	-hilmar

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================