Hi Nedim,
Can you reproduce this bulk load (collection version is better) into the
clean database and send us event logs?
Please, send also result of doc("$schema") and doc("$collection_<name>").
Ivan
Hello,
>
>
> > It depends on data itself and the way you store it in Sedna
> > (collections or standalone documents).
> > Do you use collections?
> > What is the size of *.sedata file in the database folder?
>
> I imported 100 documents into two Sedna databases, one with all the
> documents in one collection (bbbb), and the other one without
> collections (aaaa). These are the file sizes in the data folder for the
> databases:
>
> No collections:
>
> total 15G
> 51M aaaa.61.llog
> 16G aaaa.sedata
> 250M aaaa.setmp
>
> Collection:
>
> total 12G
> 87M bbbb.101.llog
> 13G bbbb.sedata
> 250M bbbb.setmp
>
> You can see that the bbbb database takes 3GB (20%) less disk space. I
> presume this is because only one descriptive schema is generated? I
> believe this is the right way for me to go.
>
> I created both databases with the same parameters:
>
> se_cdb -data-file-ext-portion 1024 -tmp-file-init-size 250
> -data-file-init-size 2048 -bufs-num 16384 <name>
>
> I noticed that data loading lasts significantly longer (1 hour) for the
> bbbb database (with a collection) than for the aaaa database (20
> minutes). I also noticed that the size of the aaaa database data folder
> grows from 14GB to 15GB after I shut down the database.
>
> So, do you think that the disk usage will grow linearly with the rest of
> my 65k files? Should I then expect 650 * 12GB = 7800GB of disk space
> usage and 650 * 1hour = 650 hours of inserts?
>
>
>
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
