[PLUG] Database layout vs. performance Addendum

[Alex Daniloff]

Brian,

We already have our modules written in Perl which resemble subselects,
triggers, stored functions and other features MySQL doesn't have. 
At least for for now.

I assume that Sybase is free to use in development systems, but what
about using it in commercial applications? How much It'll cost and
what is its lisence schema? 
We just don't want to have additional head aches with commercial EULA
and other greedy needy stuff.

By the way, you've mentioned that Perl FCGI is dieing under a heavy
load. Did you mention FCG not FCGI? CGI is prone to consume a lot of
system resources because Perl script must be interpreted, compiled and
executed upon every user request.  
In case with FCGI the script is interpreted, compiled and executed
only once. After this it runs persistently servicing multiple users
requests. If there are too many users for one process, web server
spawns second third and so on process untill bandwidth is saturated.
Generally properly written Perl FCGI script runs faster than PHP.



  



-------------------
> Another reason to try to pimp sybase out is the creation of
functions that 
> are stored in the database....without needing to write C/C++ code --
you can 
> use standard SQL-T/SQL (similar with PostgreSQL, but without the
T/SQL 
> stuff....)
> 
> Sybase 11.9.2 is free for linux for use in development systems...I
can send 
> or point you to the RPMs...
> 
> The creation of PROCS (stored procedures) is a great thing because
the query 
> is already compiled. 
> 
> I apologize if I am attempting to steer you away from your original
plan...
> 
> 
> 
> 
> On Friday 17 May 2002 05:50 pm, you wrote:
> > In most cases there are no more than three to five joints in
general
> > SELECT query.
> >
> >
> > -------------------
> >
> > > Another thing to consider is your table layout:
> > >
> > > 1) How normalized will your data structure be?
> > > 2) Can you avoid 15-table joins for a general SELECT statement?
> > >
> > > There are alot of things in addition to disk placement that can
> >
> > utilize or
> >
> > > inhibit a database's response...
> > >
> > >
> > >
> > >
> > > --
> > > Brian Horan
> > > bhoran at hexdev.com
> > >
> > > _______________________________________________
> > > PLUG mailing list
> > > PLUG at lists.pdxlinux.org
> > > http://lists.pdxlinux.org/mailman/listinfo/plug
> >
> > _______________________________________________
> > PLUG mailing list
> > PLUG at lists.pdxlinux.org
> > http://lists.pdxlinux.org/mailman/listinfo/plug
> 
> -- 
> Brian Horan
> bhoran at hexdev.com
> 
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>