1. db vs. db
What makes Tsunami better than EDS?
What makes MySQL or PostgreSQL better than Tsunami or EDS?
What makes [your favorite db] better than [any other db]?
What's the best for web serving? I'm hoping to have a EUPHORIA-driven web
site soon, and it's also going to be database driven. Will EDS suffice for
one hit per second? a billion hits?
What's the best (if anything) for small-app, not-web-related, data
management?
2. Re: db vs. db
- Posted by euman at bellsouth.net
Jun 18, 2003
On 18 Jun 2003 at 15:15, C. K. Lester wrote:
>
>
> What makes Tsunami better than EDS?
> What makes MySQL or PostgreSQL better than Tsunami or EDS?
> What makes [your favorite db] better than [any other db]?
>
> What's the best for web serving? I'm hoping to have a EUPHORIA-driven web
> site soon, and it's also going to be database driven. Will EDS suffice for
> one hit per second? a billion hits?
> What's the best (if anything) for small-app, not-web-related, data
> management?
Tsunami Pro can have 65,000 files open at once with one instant of the .dll
loaded
but you could have multiple instances of the TRMPRO.DLL running having virtually
an endless amount of open files. (drawback is processor speed and bandwidth)
I wrote a wrapper for Tsunami that should work with the free version of Tsunami
and will probably need tweaks in certain areas but what Ive used it for, it
seems
to not only be faster than EDS but more extensive as well.
Euman
3. Re: db vs. db
> I wrote a wrapper for Tsunami that should work with the free version of
Tsunami
> and will probably need tweaks in certain areas but what Ive used it for,
it seems
> to not only be faster than EDS but more extensive as well.
>
> Euman
Hey! I'm running the demos you have and getting the error message box,
"trm_Open ... Result code = 1"
I'm not sure that's what I should be getting according to the code...
Any hints/tips?
4. Re: db vs. db
- Posted by euman at bellsouth.net
Jun 18, 2003
On 18 Jun 2003 at 15:45, C. K. Lester wrote:
>
>
> > I wrote a wrapper for Tsunami that should work with the free version of
> Tsunami
> > and will probably need tweaks in certain areas but what Ive used it for,
> it seems
> > to not only be faster than EDS but more extensive as well.
> >
> > Euman
>
> Hey! I'm running the demos you have and getting the error message box,
> "trm_Open ... Result code = 1"
>
> I'm not sure that's what I should be getting according to the code...
>
> Any hints/tips?
You'll have needed to create TRMDEMO.DAT file first...
I used the Masm32 demo to create the demo file.
sorry bout that....it will be over 500k, I could send it to you if you like
or create it yourself either way..
5. Re: db vs. db
> > Hey! I'm running the demos you have and getting the error message box,
> > "trm_Open ... Result code = 1"
> >
> > I'm not sure that's what I should be getting according to the code...
> >
> > Any hints/tips?
>
> You'll have needed to create TRMDEMO.DAT file first...
> I used the Masm32 demo to create the demo file.
>
> sorry bout that....it will be over 500k, I could send it to you if you
like
> or create it yourself either way..
Hey, I actually had the Tsunami web site create me a data file that's 5.77
MB!!!! I think I chose the 30,000 records option. heh.
If I just rename that file to TRMDEMO.DAT, will that suffice? I'll try it in
the interim of waiting for your response.
6. Re: db vs. db
- Posted by euman at bellsouth.net
Jun 18, 2003
On 18 Jun 2003 at 16:01, C. K. Lester wrote:
>
>
> > > Hey! I'm running the demos you have and getting the error message box,
> > > "trm_Open ... Result code = 1"
> > >
> > > I'm not sure that's what I should be getting according to the code...
> > >
> > > Any hints/tips?
> >
> > You'll have needed to create TRMDEMO.DAT file first...
> > I used the Masm32 demo to create the demo file.
> >
> > sorry bout that....it will be over 500k, I could send it to you if you
> like
> > or create it yourself either way..
>
> Hey, I actually had the Tsunami web site create me a data file that's 5.77
> MB!!!! I think I chose the 30,000 records option. heh.
>
> If I just rename that file to TRMDEMO.DAT, will that suffice? I'll try it in
> the interim of waiting for your response.
>
Chris did you get the wrappers from the Tsunami site?
http://www.trm-ug.com/files/TRM25_EU_0618171305.ZIP
Euman
7. Re: db vs. db
> Chris did you get the wrappers from the Tsunami site?
> http://www.trm-ug.com/files/TRM25_EU_0618171305.ZIP
Got 'em from your site, actually... :)
8. Re: db vs. db
On Wed, 18 Jun 2003 15:15:02 -0500, "C. K. Lester"
<cklester at yahoo.com> wrote:
<Disclaimer: I'm only guessing here ;->
>
>What makes Tsunami better than EDS?
Adding thousands of records and/or having it permanently running on
the server (eg linked into Apache/whatever). IIRC, It is also a proper
database system (see below re eds)
>What makes MySQL or PostgreSQL better than Tsunami or EDS?
Openness. Any platform, and very nearly all programming languages can
submit an SQL query string. Theoretically the slowest of all interface
mechanisms for dumb queries and actually/obviously the fastest of the
lot for detailed/intelligent queries.
>What makes [your favorite db] better than [any other db]?
Because it has a pink [insert you favorite colour here] logo
>
>What's the best for web serving? I'm hoping to have a EUPHORIA-driven =
web
>site soon, and it's also going to be database driven. Will EDS suffice =
for
>one hit per second? a billion hits?
eds will almost certainly be the fastest for small data sets,
especially if the database engine itself is reloaded for each web hit.
SQL would probably take 20 seconds to load on my (slow, ancient)
machine, but is definitely bog-standard [available if not always
enabled] on almost all web servers. You'd have to check Tsunami
support yourself.
I don't think very many web servers will cope with a billion hits per
second. A bankload of routers in front of a server farm, perhaps
.
>What's the best (if anything) for small-app, not-web-related, data
>management?
there is a much shallower learning curve on eds for simple databases;
however bear in mind that you cannot specify multiple indexes or any
dbms-understood relationships within your data; they all have to be
coded by hand. EDS keys and data also are totally unnamed which is
initially easier but later on will dump that responsibility right back
on the programmer.
If you don't know eds, you should learn it anyway.
Sadly, E.F. Codd died earlier this year. A lot of his stuff was deeply
theoretical, but if you are at all interested in creating and defining
databases you really ought at least get a gist of his ideas. I'm sure
you will find thousands of references via Google.
Pete
9. Re: db vs. db
- Posted by gertie at visionsix.com
Jun 19, 2003
On 19 Jun 2003, at 22:57, Pete Lomax wrote:
<snip>
> I don't think very many web servers will cope with a billion hits per
> second. A bankload of routers in front of a server farm, perhaps.
With that "reverse proxy" thing that kat has been harping about.
Kat
