Re: Possible DBIx::Recordset changes
At Fri, 14 Nov 2003 13:29:45 +0100, Kaare Rasmussen wrote: > > 3. I'd like an enhancement to make IN work with placeholders, but > > Same. > Now we're talking placeholders, I'd like them to work anywhere. It's > necessary with subselects with where-clauses. If your database can actually take advantage of placeholders in order to pre-parse the request (and generate a search plan, etc), then where it allows placeholders is up to it. -- - Gus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DBIx::Recordset and POE
Hi Anybody here with experience in using DBIx::Recordset with POE ? I want to write a POE-server to serve data from a database using DBIx::Recordset. I wonder if I have to be concerned with time consuming database queries in this concept. I'm worried that POE will not service requests while a database query is being processed, but I'm not sure if this is a problem or not. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: DBIx::Recordset and POE
Hi, > > Anybody here with experience in using DBIx::Recordset with POE ? > > I want to write a POE-server to serve data from a database using > DBIx::Recordset. > > I wonder if I have to be concerned with time consuming database > queries in this concept. I'm worried that POE will not service > requests while a database query is being processed, but I'm not sure > if this is a problem or not. Yes, this would be a problem. Your POE server will not serve any request while a database query is happening. There is a DBI module for POE, which spawns a subprocess, so the main POE server is still responsive. I think you have to bring this POE DBI module and DBIx::Recrdset together to really take advantage of POE Gerald -- Gerald Richter ecos electronic communication services gmbh IT-Securitylösungen * dynamische Webapplikationen * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122 WWW:http://www.ecos.de/ Fax: +49 6133 939-333 -- | | ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info | +- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Locks on sessions database
Vijaya Dasari wrote:
> Hi,
>
> We have problem with locking of rows in the session database. We are
> using postgres as the Store.
>
How does your Embperl session configuration look like?
Gerald
> Configuration of the system is Apache 2.0.47 + Embperl 2.0b9 +
> mod_perl 1.99_09
>
> I tried using MySQL as Store, but still the same problem.
>
>> 40 | sessions | localhost | sessions | Query | 313 | User lock |
> SELECT GET_LOCK('Apache-Session-30fac6623276e16798300d56c8de3989',
> 3600)
>>
>> 41 | sessions | localhost | sessions | Query | 266 | User lock |
> SELECT GET_LOCK('Apache-Session-30fac6623276e16798300d56c8de3989',
> 3600)
>>
>
> Two processes are trying to acquire a lock ( seems simultaneously ) on
> the same session id (row).
> We did not had this problem with Apache 1.3
>
> I tried to use Semaphore combinations, but has the same problem.
>
> Thanks in advance,
> Vijaya.
>
>
> ---
> Vijaya Krishna Dasari
> Heinz Nixdorf Zentrum fuer Informationsmanagement in der
> Max-Planck-Gesellschaft (ZIM)
> Phone: +49-89-3299-1557
> Fax: +49-89-3299-1555
> E-Mail: [EMAIL PROTECTED]
> http: www.zim.mpg.de
> Boltzmannstrasse 2/ITER Gebaeude
> D- 85748 Garching
> GERMANY
> ---
>
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
Gerald Richter ecos electronic communication services gmbh
IT-Securitylösungen * dynamische Webapplikationen * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122
WWW:http://www.ecos.de/ Fax: +49 6133 939-333
--
|
| ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info
|
+-
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Wiki and/or Forum
Benni: You will find a forum in the next version of EplSite. EplSite 2 will be released in a few days and it works with EmPerl 1.36 and 2.0b9. Please visit us in http://www.eplsite.org in a few days. Calos Kassab > Hi! > > Is there an WikiWiki and/or an discussion-forum programmed with > EmbPerl available as free software? > > Benni > -- > http://www.aymargeddon.de > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
apache shutdown errors
Hi All, I've just resubscribed to the list since I'm working on an Embperl-based project, the first serious one in many months. I'm using a compiled version Apache/mod_perl/Embperl2 on RH9. Here is the HTTP server string: Server: Apache/1.3.27 (Unix) Embperl/2.0b9 mod_perl/1.27 mod_ssl/2.8.14 OpenSSL/0.9.7a When stopping Apache (via apachectl stop), the following line appears about 30 times in the error log: Attempt to free unreferenced scalar during global destruction. This happens even when stopping Apache immediately after starting it. I did some Google searches, and found postings from other mod_perl users who had no idea where it was coming from. I switched from 'PerlModule Embperl' to a startup.pl with the following: use Apache; use DBI; use DBD::Pg; use Apache::Session; use Apache::SessionX; use Apache::Session::Store::Postgres; use Embperl; use Embperl::Object; But that didn't help either. Everything is working fine, include the sessions, but it would still be nice to clean up this error. Ideas, anyone? Wim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
