pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Ruprecht <chrup999@yahoo.com>
To: Mitch Vincent <mitch@doot.org>
Cc: PostGreSQL PHP Group <pgsql-php@postgresql.org>
Subject: Re: pg_pconnect - ??
Date: Mon, 28 Jan 2002 17:13:04 -0600
Message-ID: <p0510121db87b8893d28c@[192.168.0.6]> (raw)
In-Reply-To: <017901c1a848$eec1bb30$0200000a@Mitch>
References: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net>
	<p05101219b87b70bd3c70@[192.168.0.6]>
	<017901c1a848$eec1bb30$0200000a@Mitch>

<Grin> - yes, I do the indexing and all that good stuff - even 
casting the variables on my select statements. But no matter what you 
do, it takes time to go through half a million records and add them 
up in a certain way (sub totals when a value changes). I made sure 
that I have the right indexes and that they are selected, when I do 
the 'select'. I'm not new to databases & sql and all that stuff, just 
new to PHP. I also don't allow the user to enter SQL statements 
directly or let them do dynamic queries where they can specify their 
own 'where' or 'order by' or stuff like that.


At 15:12 -0700 01/28/2002, Mitch Vincent wrote:
>  > The most traffic the user creates is when they change their rate
>>  table, they might add 20 to 50 rates at per week. I could run that
>>  stuff of an old 100 MHz Pentium with 16 MB RAM, if I had to and they
>>  would probably not see and performance issues. However, some of the
>>  bills they have process 500'000 line items at a time, this is where I
>>  need the horsepower - but at that stage, the connection is already
>>  made. The query runs across 4 tables and sometimes takes up to 4
>>  minutes.
>
>If you post schema and queries then perhaps we could help you get that time
>down a bit? Pardon the questions but you're indexing, VACUUM ANALYZE ' ing
>and using EXPLAIN to see what your query plans are -- right?
>
>I guess if we're going to open this can of worms we'd better take the
>conversation to pg-general though...

Uhmm - no need :).

Best regards,
Chris
-- 
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




view thread (26+ messages)  latest in thread

Message-ID: <p0510121db87b8893d28c@[192.168.0.6]>
Permalink:  ../p0510121db87b8893d28c@%5B192.168.0.6%5D/
Also on:    postgresql.org/message-id/p0510121db87b8893d28c@[192.168.0.6]

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: chrup999@yahoo.com, mitch@doot.org
  Subject: Re: pg_pconnect - ??
  In-Reply-To: <p0510121db87b8893d28c@[192.168.0.6]>
  References: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net> <p05101219b87b70bd3c70@[192.168.0.6]> <017901c1a848$eec1bb30$0200000a@Mitch> <p0510121db87b8893d28c@[192.168.0.6]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox