Re: Scalable DB Solution?
On 1 Feb 2001, at 10:44, CK Lester wrote:
> Kat,
>
> I'm needing to create a database. It will be huge and consist of multiple
> databases.
The database doesn't care about that. I have one that's 52megs and in some 600
separate files. It is expandable in any dimension. Several of the files have
executeable
code as data, but i can't exec those lines in Eu ,, yet,, but they certainly add
a new
thread of coding to mirc.
>It will be working behind the scenes on an upcoming website, so
> that means multiple queries at one time (multi-threaded, right?).
That's a software program, if you want the software to do that, write it that
way, the
database doesn't care. To do what you want tho, the software does not haveto be
multi
threaded, in fact, i wouldn't for this application, i'd queue the data requests
and run
them one at a time, less overall overhead. In the World Wide Wait, even a few
seconds
of time waiting in the database manager queue isn't a problem, after all, your
puter has
only one cpu anyhow, and on a commercial web host, you are prolly getting only
one
shared cpu too. Tiggr has a serialized front end, multithreaded data
transmission
cause it was easy, but it is essentially serialized going back out thru the
winsock
anyhow, since it's one cpu on one puter, so it could just as well been written
as one
serial "black box" of code. No matter what i do, i haveto wait on winsock, which
seems
to be limited to a bit over a megabit/sec from any one application, which would
be your
web interface frontend software. So do it which ever way is easiest for you and
your
puter's OS (i don't know about *nix on multi-cpu puters).
> So, XML/SGML are just formatted data files that ANY XML/SGML-enabled
> database manager can manage, right?
Prolly not, i'd imagine each proprietary manager uses different tags amd has
different
restrictions and abilities. Your first question was about the database. I can't
tell you
anything about any/every manager out there, but XML tags are the way to go for
the
database itself.
>It is also this manager that will serve
> the data to the web, correct?
That's another software question, nothing to do with the database itself. If you
want it
to interface to the web, that's doable, Tiggr does it, she did it in pascal and
then mirc
first and now in Eu, so anything is possible. If you are trying to build a
custom setup
using bits and pieces from different companies to interface on a commercially
hosted
website, i wish you luck. The database may be scaleable, but i don't know about
any
choice of manager.
Kat,
thinking we are using the words differently here....
> Thanks!
> ck
>
> ----- Original Message -----
> From: "Kat" <gertie at PELL.NET>
> To: <EUforum at topica.com>
> Sent: Thursday, February 01, 2001 12:35 PM
> Subject: Re: Scalable DB Solution?
>
>
> > On 1 Feb 2001, at 10:18, CK Lester wrote:
> >
> > > Anybody have a good website for reviews of large scale databases? I'm
> > > thinking Oracle vs. DB2... Personal opinions welcome...
> >
> > Any XML/SGML database is scaleable, as far as the database management
> software
> > has the ability to read it. I did Tiggr's database in XML format from the
> start in 1991,
> > and i have not regretted it. My getxml() in Eu can read any tags i add, of
> any length or
> > subdivision. But if you are wanting to read existing databases that
> someone else
> > wrote, i can't help.
> >
> > Kat
> >
>
>
>
|
Not Categorized, Please Help
|
|
