Hi,
We have an application where we will have to
service as high as 50 queries a second.
We've discovered that most database just cannot
keep pace.
The only option we know is to service queries out
of flat files.
Can somebody give us pointers o n what modules are
available to create flat
On Wed, 11 Oct 2000, Differentiated Software Solutions Pvt. Ltd wrote:
Hi,
We have an application where we will have to service as high as 50
queries a second. We've discovered that most database just cannot keep
pace.
The only option we know is to service queries out of flat files. Can
"Differentiated Software Solutions Pvt. Ltd" wrote:
Hi,
We have an application where we will have to service as high as 50
queries a second.
We've discovered that most database just cannot keep pace.
The only option we know is to service queries out of flat files.
There is a DBD
-Original Message-
From: Perrin Harkins [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2000 04:45
To: Ajit Deshpande
Cc: [EMAIL PROTECTED]
Subject: Re: Wild Proposal :)
Hi Ajit,
It's not entirely clear to me what problem you're trying to
solve here.
I'll comment on some
hi all,
we have a query which goes to 7kb and we use mysql and php , th eserver
is literally crashing when we do the process
what is the other alternative fpor me
The site is aQuiz site
regards
rajesh mathachan
--
QuantumLink
On Tue, 10 Oct 2000, Paul Lindner wrote:
On Tue, Oct 10, 2000 at 02:43:36PM -0400, Geoffrey Young wrote:
-Original Message-
From: Peter Gebauer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 10, 2000 8:20 AM
To: [EMAIL PROTECTED]
Subject: Compiling apache
-Original Message-
From: darren chamberlain [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 06, 2000 4:41 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Adding parameters on an internal_redirect()
[EMAIL PROTECTED] ([EMAIL PROTECTED]) said something to this
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 10, 2000 11:35 PM
To: [EMAIL PROTECTED]
Subject: mod_perl on RH7 fails make test
I am trying to build mod_perl-1.24 on apache_1.3.12 on
RedHat linux 7.0 2.2.16-22 gcc version 2.96
On Wed, 11 Oct 2000, Differentiated Software Solutions Pvt. Ltd wrote:
Hi,
We have an application where we will have to service as high as 50 queries a second.
We've discovered that most database just cannot keep pace.
The only option we know is to service queries out of flat files.
--- On 10/10/2000 11:46:14 PM bcburke wrote: ---
You can use Perl's IPC::Shareable to share objects in memory across
processes:
http://theoryx5.uwinnipeg.ca/CPAN/data/IPC-Shareable/IPC/Shareable.html
Good luck,
Thanks for your reply,
I read through the
On Thu, 12 Oct 2000 [EMAIL PROTECTED] wrote:
Thanks for your reply,
I read through the documentation and IPC-Shareable is exactly what I
need. I am having some problems getting it working. (Maybe that's why you
wished me Good luck). Seems to have to do with the size option. I can tie
"Differentiated Software Solutions Pvt. Ltd" [EMAIL PROTECTED] writes:
We have an application where we will have to service as high as 50 =
queries a second.
We've discovered that most database just cannot keep pace.
The only option we know is to service queries out of flat files.
Can
mod_perl 1.24/1.3.12 perl 5.6
Here's my httpd.conf:
-
Listen 9000
VirtualHost *:9000
perl
package My::DirectoryIndex;
use Apache::Constants qw( DECLINED );
sub handler {
my $r = shift;
$r-log_error(
I've been looking for this segfault for a while.
This may be related to my last post about the double requests under
mod_perl because if I use a cgi-script instead of a mod_perl handler I
don't get the segfault. But there's an issue with mod_rewrite, too.
I have a url that can go to an
I installed a handler as such:
httpsd.conf:
-
PerlModule Tofu::Tofuhandler
Location /userfiles
SetHandler perl-script
PerlHandler Tofu::Tofuhandler
/Location
Location /
AddHandler perl-script *.html
PerlHandler Tofu::Tofuhandler
/Location
I then noticed that URI's of
On Wed, 11 Oct 2000, Matt Sergeant wrote:
Most modern DBMS software should be able to handle 50 queries per second
on decent hardware, provided the conditions are right. You're not going to
get anything better with flat files.
Hmm... I guess it all depends on what your queries look like, but
Can I get the value of a PerlSetVar at startup?
# Main server config
PerlSetVar foo bar
VirtualHost 80
perl
package My::Handler;
use strict;
# Is there a way to get at 'foo'?
my $foo = Apache-dir_config('foo');
sub handler {
...
}
/perl
Perl*Handler
On Wed, 11 Oct 2000, Sander van Zoest wrote:
On Wed, 11 Oct 2000, Matt Sergeant wrote:
Most modern DBMS software should be able to handle 50 queries per second
on decent hardware, provided the conditions are right. You're not going to
get anything better with flat files.
Hmm... I
On Wed, 11 Oct 2000, Bill Moseley wrote:
Can I get the value of a PerlSetVar at startup?
# Main server config
PerlSetVar foo bar
VirtualHost 80
perl
package My::Handler;
use strict;
# Is there a way to get at 'foo'?
my $foo = Apache-dir_config('foo');
On Wed, 11 Oct 2000, Matt Sergeant wrote:
I really think that sometimes going for a flat file layout *can* be much
more reliable and scalable then RDBMS software. It all really depends on
what you plan to do with the data and what you would like to get out of
it.
I think you chose the
On Wed, 11 Oct 2000, Sander van Zoest wrote:
On Wed, 11 Oct 2000, Matt Sergeant wrote:
Lots of places use databases for read-only queries. Having a database
that gets lots of similar queries that are read-only makes it an
unnecessary single point of failure. Why not use the local disk and
On Wed, 11 Oct 2000, Matt Sergeant wrote:
On Wed, 11 Oct 2000, Sander van Zoest wrote:
On Wed, 11 Oct 2000, Matt Sergeant wrote:
Lots of places use databases for read-only queries. Having a database
that gets lots of similar queries that are read-only makes it an
unnecessary single
Caveat : I have built modperl on a gazillion unix boxes. This win32 is
black magic to me so I have no idea what I am doing, I just need to get
mod_perl running under NT desperately. That said, here is my current situation.
Running
ActiveState Perl build 618
Apache 1.3.12
I ppm'd the
Update your PATH evironment variable to include C:\Perl\lib
-Carlos
"siberian.org" wrote:
Caveat : I have built modperl on a gazillion unix
boxes. This win32 is
black magic to me so I have no idea what I am doing, I just need to
get
mod_perl running under NT desperately. That said, here is my
I tried that ( and again ) with no luck :
set PATH=C:\Perl;C:\Perl\lib;C:\Perl\bin;C:\WINNT;C:\WINNT\system32
but apache gives me the same error. @INC is only consisting of
C:\winnt\system32\lib which isn't even in my Path environment variable. I
have no idea where Apache is getting its @INC
Are you able run perl from a DOS terminal? i.e. perl -v (without having
to run set PATH ...)
If not, your Perl PATH is not set. Try setting your system environment
via:
right-click on My Computer and select Properties, then set the System
environment PATH variable by clicking on the Environment
Yup, from DOS shell everything works great. Perl runs great. I tried
setting my path via the properties ( you were correct, DOS only sets it for
the session and not for the system ) but it had no impact on apache.
Apache.exe still looks only in the winnt\system32\lib directory.
Windows is a
On Wed, 11 Oct 2000, Stephen Anderson wrote:
There's DBI::Proxy already. Before jumping on the "we need pooled
connections" bandwagon, you should read Jeffrey Baker's post on the
subject here:
http://forum.swarthmore.edu/epigone/modperl/breetalwox/38B4DB3F.612476CE@acm
.org
People
Like the error message says, try to find the global.asa
that should have been in the ./eg directory and add it
there.
Otherwise, try a fresh install using perl's CPAN,
"perldoc CPAN" for more info, for Apache::ASP to get
the global.asa and .htaccess that comes with the examples.
It may also be
Hi,
We had a similar problem with postgres db.
We had a large query running to 3 kb and the query ran forever without ever
getting completed.
We solved this, by breaking the query into parts and executing each part
separately... i.e., by creating a hash of the output of one step and filter
it
RM we have a query which goes to 7kb...
"7 kb"? I don't mean to be picky, but do you mean "seven kilo-bytes"? I'm
thinking that either you mean some much larger number, or that I'm missing
something terribly.
Either way, what does your query look like? Are you joining across 3 tables and
then
On Wed, Oct 11, 2000 at 08:24:13PM -0700, Rodney Broom wrote:
RM we have a query which goes to 7kb...
"7 kb"? I don't mean to be picky, but do you mean "seven kilo-bytes"? I'm
thinking that either you mean some much larger number, or that I'm missing
something terribly.
I read this as
DB I read this as meaning the QUERY string is 7k in size, not the result set.
Hmm, I didn't think of that. Yes, that would be a big query.
DB ...the words 'stored
DB procedure' come to mind (but that's always another story)
Yes, no stored proceedures in mysql. But if this does refer to 7KB of
33 matches
Mail list logo
