Re: [bdbxml] Cross-container query without specifying containers
"Kiril Stankov" <[email protected]> Mon, 20 Feb 2006 20:42:45 +0200
| Newsgroups | gmane.comp.db.dbxml.general |
|---|---|
| Message-ID | <[email protected]> |
--=__Part694BDDB5.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Thanks for the fast reply! =20 The problem is not the size, but the number of XML documents, which can be = stored in a container. I know that 2^32 is a lot, but I am working on an application, which needs = to keep all previous versions of each item. In terms of few years the = above number of documents may be reached and I want to avoid the "What we = do now?" question. I suppose that what I need to do is track the number of items and create a = new container when the limit is reached. XQuery then may be used to = iterate over containers (I guess that collection() can take a parameter). =20 Regards, =20 Kiril. >>> Tom McCubbin <[email protected]> 2/20/2006 8:25:09 pm >>> In the current version this is not possible. And i'm curious, as containers are stored in BDB database files where =20 Key / Value pairs can be 2^32 ( 4 Gig ) each in size, and the overall = db=20 can be up to 256 terra bytes, of course possibly limited by the platform=20= / file system, since when does a container cap out @ 4gig? What=20 platform are your working on? -tom Kiril Stankov wrote: > Hi, > =20 > I wonder if it is possible to search for documents in all existing=20 > containers, without explicitly providing containers' names. > What I try to figure out is what to do when reaching the 2^32 limit = of=20 > a container. Will it be possible to simply create another one and=20 > start storing data in it, designing all queries in such a way that=20 > they are container-insensitive. > =20 > Thanks in advance! > =20 > Kiril. --=__Part694BDDB5.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"> <META content=3D"MSHTML 6.00.3790.2577" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Trebuchet MS"> <DIV>Thanks for the fast reply!</DIV> <DIV> </DIV> <DIV>The problem is not the size, but the number of XML documents, which = can be stored in a container.</DIV> <DIV>I know that 2^32 is a lot, but I am working on an application, which = needs to keep all previous versions of each item. In terms of = few years the above number of documents may be reached and I want to avoid = the "What we do now?" question.</DIV> <DIV>I suppose that what I need to do is track the number of items = and create a new container when the limit is reached. XQuery then may be = used to iterate over containers (I guess that collection() can take a = parameter).</DIV> <DIV> </DIV> <DIV>Regards,</DIV> <DIV> </DIV> <DIV>Kiril.</DIV> <DIV><BR><BR>>>> Tom McCubbin <[email protected]> = 2/20/2006 8:25:09 pm >>><BR>In the current version this is not = possible.<BR><BR>And i'm curious, as containers are stored in BDB database = files where <BR>Key / Value pairs can be 2^32 ( 4 Gig ) each in = size, and the overall db <BR>can be up to 256 terra bytes, of course = possibly limited by the platform <BR>/ file system, since when does a = container cap out @ 4gig? What <BR>platform are your working = on?<BR><BR>-tom<BR>Kiril Stankov wrote:<BR><BR>> Hi,<BR>> = <BR>> I wonder if it is possible to search for documents in all = existing <BR>> containers, without explicitly providing containers' = names.<BR>> What I try to figure out is what to do when reaching the = 2^32 limit of <BR>> a container. Will it be possible to simply create = another one and <BR>> start storing data in it, designing all queries = in such a way that <BR>> they are container-insensitive.<BR>> = <BR>> Thanks in advance!<BR>> <BR>> Kiril.<BR><BR><BR></DIV>= </BODY></HTML> --=__Part694BDDB5.0__=--