connection pooling

Hello embperl, How do you manage DBI connections? I have read something in Tips&Tricks but this approach IMHO can be slow on heavy loaded servers. Regards Lukas Zapletal [[EMAIL PROTECTED]] web programmer Bach systems Ltd., Czech Republic --- PGP FINGERPRINT 4BA4

Where to modify @INC

Hello embperl, I need to find place for configuring perl includes. I use httpd.conf: SetEnv PERLLIB 'D:/Inetpub/libperl' but PERLLIB is comma-separated and I do not know how to set 'D:/'. Is there any other place where to set it? Regards Lukas Zapletal [[EMAIL PROTECTED]] web programmer

Re[3]: Two frame application

Olá lukas, Reply to your message: LFBR>> If you put the $req stuff into [!!] block it will be executed just the LFBR>> first time the page is loaded. LZ> Hmmm either in CGI mode? In CGI mode you can't use $req because $req is a feature available when you run Embperl under of mod_perl. Sem mai

Apache::DBI

Hello embperl, have anyone experiences with running Apache::DBI on WinNT ? I cannot connect to a database... it returns undef. lzap Regards Lukas Zapletal [[EMAIL PROTECTED]] web programmer Bach systems Ltd., Czech Republic --- PGP FINGERPRINT 4BA4ECA3EDE960855

Re: Re[2]: Two frame application

> > Hmmm either in CGI mode? > when running as CGI script everytime is the first time Gerald - Gerald Richterecos electronic communication services gmbh Internetconnect * Webserver/-design/-datenbanken * Consulting Post:

Re: connection pooling

> > How do you manage DBI connections? under mod_perl use Apache::DBI, when running CGI the only chance is to use DBI::ProxyServer. Sometime ago I have some patches to DBI::ProxyServer, to make it useable in this way, but I am not sure if they are already gone into the main DBI distribution. > I

Re: Where to modify @INC

> > I need to find place for configuring perl includes. > > I use httpd.conf: > > SetEnv PERLLIB 'D:/Inetpub/libperl' > > but PERLLIB is comma-separated and I do not know how to set 'D:/'. > > Is there any other place where to set it? > I usualy set it in a startup.pl: In httpd.conf PerlR

Re: Re[3]: Two frame application

> > In CGI mode you can't use $req because $req is a feature available when > you run Embperl under of mod_perl. > You can use EMbperl's request object as Lukas does with: [- $req = shift; $req->{appname} = "test app"; -] but you can use Embperl's predefined variable $req_rec wh

Re: Apache::DBI

> > have anyone experiences with running Apache::DBI on WinNT ? > > I cannot connect to a database... it returns undef. > Just say PerlModule Apache::DBI in your httpd.conf and use DBI as usual (as you would do it when Apache::DBI isn't present). This works correctly for me under NT Gerald -

Re: self-JOIN with DBIx

> > This is normal SQL. "forummcomment" is the real name of the table. "start" > and "thread" are alias names. I need those because I use the same table > twice since it's self-referencing. > ok, I see. I have used this before for fieldnames, but not for table names. Of course it make sense in yo

Internal redirect permission?

I am running the latest apache, mod_perl, and embperl on linux. All work fine independently. However, I want to handle all browser requests through a mod_perl controller and use internal redirect to embperl "templates". I can't figure out how to set up httpd.conf to provide permissions for the

Apache::DBI (OT Kinda) Question

If I use Apache::DBI under mod_perl and continuosly open and disconnect a DBI:mysql connection, it should reuse the same connection and not perform a database lookup all the time. I have a piece of code that I can't be bothered optimising (i.e. it currently opens and closes about 30 connections

Re: Apache::DBI (OT Kinda) Question

On Wed, Sep 05, 2001 at 11:31:43AM +0930, David Lloyd wrote: > If I use Apache::DBI under mod_perl and continuosly open and disconnect > a DBI:mysql connection, it should reuse the same connection and not > perform a database lookup all the time. i presume your question is "..., right?" yes it s

Re[2]: connection pooling

Hello Gerald, Tuesday, September 04, 2001, 9:54:39 PM, you wrote: >> I have read something in Tips&Tricks but this approach IMHO can be slow on >> heavy loaded servers. GR> What do you mean here ? Maybe I didn`t understand properly. And it`s unofficial. I found the new ODBC drivers for MS SQL

Re: Apache::DBI (OT Kinda) Question

You can verify correct operation of Apache::DBI by doing the following: 1) Make sure it appears BEFORE the DBI load in your startup.pl (or equivalent) 2) Use Apache::Status and enable perl-status as needed in your httpd.conf load in this order: use Apache::Status(); use Apache::DBI(); use DBI();