J. ORIOL wrote:
I'm filling a 40 x 10 matrix of data (A string grid), that's 400
cells being calculated aproximately with 6 to 8 queries each one of
them. That's 4800 queries to fill the matrix. In the server, this
task delays 8 secs. but in the client are 40 secs.
What takes 40 seconds? If y
Thanks by your replies, Richard, Martijn.
The queries are very normal, neither complex or large. My tables are pretty
small too. (My SQL skills are the same, I'm afraid)
So, what I'm doing with my app:
I'm filling a 40 x 10 matrix of data (A string grid), that's 400 cells being
calculated apro
J. ORIOL wrote:
Hi,
I have an app working over LAN , XP + Postgres 8.2.
OK - so that's on the server, yes?
> The problem is
that a client send several queries and the processor show me 100 %
usage. (P IV 3 Ghz with 1 Gb RAM)
That's what's supposed to happen. Any process will either:
1.
On Wed, May 23, 2007 at 07:50:42AM -0500, J. ORIOL wrote:
> Hi,
>
> I have an app working over LAN , XP + Postgres 8.2. The problem is
> that a client send several queries and the processor show me 100 %
> usage. (P IV 3 Ghz with 1 Gb RAM) and stops all its tasks until
> queries finishes.
>
> Thi
