Please do not respond last email, only this...
public int cedula_actualizar(String strcedula, String strids) {
PreparedStatement ST = null;
int retVal = 0;
try {
ST = conexion.prepareStatement("UPDATE maestro_partes SET
cedula=? WHERE consecutivo_identificacion I
public int cedula_actualizar(String strcedula, String strids) {
PreparedStatement ST = null;
int retVal = 0;
try {
ST = conexion.prepareStatement("UPDATE maestro_partes SET
cedula='"+strcedula+"' WHERE consecutivo_identificacion IN ("+strids+")");
retV
itening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 22, 2005, at 8:23 AM, Sabio - PSQL wrote:
How can I improve speed on my queries. For example this query takes
one day executing itself and it has not finalized !!!
"create table tmp_partes as
PG version = 8.0 over Linux Fedora Core 3
PostgreSQL was compiled from source
Lee Wu wrote:
PG version?
Maybe worth to try NOT EXISTS instead of NOT IN
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sabio - PSQL
Sent: Tuesday, March 22, 2005 7:23 AM
To
How can I improve speed on my queries. For example this query takes one
day executing itself and it has not finalized !!!
"create table tmp_partes as select * from partes where identificacion
not in (select cedula from sujetos)"
partes have 1888000 rows, an index on identificacion
sujetos have 5
What is the form to shrink database for recover unused space?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Uwe Maiwald wrote:
Hi,
we are currently planning a very large installation of a
web-application using PostgreSQL. The application can be configured to
handle 1 database per customer, or all customers in one large database.
We plan to start with e.g. 500 customers, each of which can have 200
MB
how to implement a fulltext search on table with a varchar(300) field
and over 6 millions of records?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Yes, I am working with PostgreSQL 8.0 over linux, and make some
tablespaces but I can't query any other tablespaces with same JDBC
connection.
Scott Marlowe wrote:
On Fri, 2005-02-25 at 08:42, Sabio - PSQL wrote:
Can I do a cross tablespaces queries?
If can't, I think that this
Can I do a cross tablespaces queries?
If can't, I think that this is a good feature to implement in this
wonderful database.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
How to implement a db cluster with PostgreSQL 8?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
11 matches
Mail list logo
