[GENERAL] 26h Query.

2005-03-20 Thread Jason Leach
hi, I'm having a bit of trouble with my SQL query. It takes about 26h to run on a 3Ghz PC. I'd really like to speed this up. I put this query in a loop to iterate over 20 tables (each table including summary has 400k records), each time the table name changes. I this case it's m_alal. Each

[GENERAL] The Ghost.

1999-12-01 Thread Jason Leach
hi, Does anyone know of a thechnical brief on Pg I can look up and read? For example how it spawns a new process, uses mem, and what not. Not detailed algorithms, but an overview of how it works; and maybe a why. If no such animal exists, perhaps, is a few people are interested, we coudl

[GENERAL] Java Ex.

1999-11-17 Thread Jason Leach
hi, Does anyone have a Java example of connecting to a DB and executing a simple SQL command? Thanks, Jason