|
Below is the latest content available from this feed:
Re: howto change iiug email address.
Posted by: garage_dba@verizon.net (Bill Hamilton) - Fri, 03 Feb 2012 15:35:20 EST
Thanks.
That was easy after out that the "tabs" you refer to are buttons.
-----Original Message-----
From: Everett Mills
Sent: Friday, February 03, 2012 11:48 AM
To: ids@iiug.org
Subject: RE: howto change iiug email address. [26183]
Log into the iiug website and on the membership tab you can change your
email
address or add one specifically for the forum emails.
--EEM
>-----Original Message-----
>From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>Bill Hamilton
>Sent: Friday, February 03, 2012 11:19 AM
>To: ids@iiug.org
>Subject: howto change iiug email address. [26182]
>
>Is there any way to change my email address on this list without getting
>off the list and back on ?
>I have an issue with Hotmail in that it will not let me sort mail into
>folders because it is not pop3.
>This list is becoming quite active, so I would prefer to use another
>email address which is pop3.
>
>
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* * * * ***
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26187]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Feb 2012 15:00:20 EST
Yes.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Fri, Feb 3, 2012 at 12:54 PM, NATYURAL HORACIO <
horacio.natyural@gmail.com> wrote:
> This is really nice. Exactly what we would be needing. This would also
> prevent
> the index from ballooning up.
> Can i add fragment to an existing table with no fragments?
>
> Really thanks a lot for all the help.
>
>
>
>
>
>
>
--e89a8f234cd3d26a3404b814c2a2
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26186]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: quickest way to drop all referential contr....
Posted by: yunyaoqu@gmail.com (FRANK) - Fri, 03 Feb 2012 13:45:51 EST
Bill, you want to have a
*weapon of mass destruction* ? ?
oh, NO... :-) kidding...
Thanks,
Frank
On Fri, Feb 3, 2012 at 12:15 PM, Bill Hamilton <garage_dba@hotmail.com>wrote:
> Thanks, Jack.
> I can do that with the sql below and then drop them in a FOREACH as you
> suggested.
> I was hoping there was some powerful utility to drop all referential
> constraints.
>
> SELECT x.constrname[1,64] as CON,
> i.idxname[1,64] as IDX,
> t.tabname[1,32] as TAB,
> c.colname[1,32] as COL,
> ttt.tabname[1,32] AS REFTAB
> FROM systables t, sysconstraints x, syscolumns c,
>
> sysindexes i, sysreferences r, systables ttt
> WHERE t.tabid = x.tabid and t.tabid = c.tabid
> and x.idxname = i.idxname
> and (part1 = colno or part2 = colno or part3 = colno or part4=colno or
> part5=colno or part6=colno)
> and x.constrtype = 'R'
> and r.ptabid = ttt.tabid and r.constrid = x.constrid
> ORDER BY 1;
>
> -----Original Message-----
> From: Jack Parker
> Sent: Thursday, February 02, 2012 5:37 PM
> To: ids@iiug.org
> Subject: Re: quickest way to drop all referential contr.... [26156]
>
> in essence. Muck with it as you like.
>
> Essentially join systables with syscontraints and sysindexes.
>
> FOREACH
>
> SELECT tabname, constrname, e.colname col1, f.colname col2
>
> INTO p_tabname, p_constrname, p_col1, p_col2
>
> FROM systables a, sysconstraints b, mytabs c, sysindexes d,=20
>
> syscolumns e, outer syscolumns f
>
> WHERE a.tabname=3Dlower(c.tabname)
>
> AND a.tabid=3Db.tabid
>
> AND b.constrtype=3D'P'
>
> AND b.idxname=3Dd.idxname
>
> AND a.tabid=3De.tabid
>
> AND d.part1=3De.colno
>
> AND a.tabid=3Df.tabid
>
> AND d.part2=3Df.colno
>
> drop constraint p_constrname
>
> END FOREACH
>
> On Feb 2, 2012, at 5:48 PM, Bill Hamilton wrote:
>
> > Is there a super quick way to drop ALL referential constraints and =
> indexes=20
> > behind them?=20
> >=20
> > I would like to put all indexes into a space with a larger page size.=20=
>
> > I wrote a program one time that consumes dbschema outut and writes
> sql=20=
>
> > statements to drop and then add indexes.=20
> > What I ran into was that when an index is dropped (one that I added =
> before the=20
> > constraints) the engine renames the index to=20
> > a name of his choice and then the =93add index=94 fails because there =
> is=20
> > already and index on that column.=20
> >=20
> > The simplest approach appears to be to write a program to grab all the =
> index=20
> > adds and referential constraint adds and generate sql=20
> > statements to *drop* all indexes and all constraints. Then, after =
> running that=20
> > sql just grab the part of the dbschema output that adds them=20
> > and globally replace =93btree=94 with =93btree in idxspace=94 , save =
> the file=20
> > and run it through dbaccess.=20
> > I suppose one of you gurus would hammer the syscontraints table, etc. =
> I=92m=20
> > too chicken.=20
> > That part of the schema is about 4260 lines, so doing in an editor is =
> not=20
> > looking like a plan.=20
> >=20
> > So is there a better plan? Some magic Kagle unix script that I can =
> convert to=20
> > run through Windows?=20
> >=20
> >=20
> > =
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **=
> * * * * *=20
> > =20=
>
> >=20
>
>
>
>
>
>
>
>
>
>
>
>
--f46d043be25673fe7e04b813b869
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26185]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: horacio.natyural@gmail.com (NATYURAL HORACIO) - Fri, 03 Feb 2012 12:54:35 EST
This is really nice. Exactly what we would be needing. This would also prevent
the index from ballooning up.
Can i add fragment to an existing table with no fragments?
Really thanks a lot for all the help.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26184]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
RE: howto change iiug email address.
Posted by: Everett.Mills@nationalbeef.com (Everett Mills) - Fri, 03 Feb 2012 12:48:15 EST
Log into the iiug website and on the membership tab you can change your email
address or add one specifically for the forum emails.
--EEM
>-----Original Message-----
>From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>Bill Hamilton
>Sent: Friday, February 03, 2012 11:19 AM
>To: ids@iiug.org
>Subject: howto change iiug email address. [26182]
>
>Is there any way to change my email address on this list without getting
>off the list and back on ?
>I have an issue with Hotmail in that it will not let me sort mail into
>folders because it is not pop3.
>This list is becoming quite active, so I would prefer to use another
>email address which is pop3.
>
>
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* * * * ***
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26183]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
howto change iiug email address.
Posted by: garage_dba@hotmail.com (Bill Hamilton) - Fri, 03 Feb 2012 12:19:12 EST
Is there any way to change my email address on this list without getting off
the list and back on ?
I have an issue with Hotmail in that it will not let me sort mail into folders
because it is not pop3.
This list is becoming quite active, so I would prefer to use another email
address which is pop3.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26182]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: quickest way to drop all referential contr....
Posted by: garage_dba@hotmail.com (Bill Hamilton) - Fri, 03 Feb 2012 12:15:55 EST
Thanks, Jack.
I can do that with the sql below and then drop them in a FOREACH as you
suggested.
I was hoping there was some powerful utility to drop all referential
constraints.
SELECT x.constrname[1,64] as CON,
i.idxname[1,64] as IDX,
t.tabname[1,32] as TAB,
c.colname[1,32] as COL,
ttt.tabname[1,32] AS REFTAB
FROM systables t, sysconstraints x, syscolumns c,
sysindexes i, sysreferences r, systables ttt
WHERE t.tabid = x.tabid and t.tabid = c.tabid
and x.idxname = i.idxname
and (part1 = colno or part2 = colno or part3 = colno or part4=colno or
part5=colno or part6=colno)
and x.constrtype = 'R'
and r.ptabid = ttt.tabid and r.constrid = x.constrid
ORDER BY 1;
-----Original Message-----
From: Jack Parker
Sent: Thursday, February 02, 2012 5:37 PM
To: ids@iiug.org
Subject: Re: quickest way to drop all referential contr.... [26156]
in essence. Muck with it as you like.
Essentially join systables with syscontraints and sysindexes.
FOREACH
SELECT tabname, constrname, e.colname col1, f.colname col2
INTO p_tabname, p_constrname, p_col1, p_col2
FROM systables a, sysconstraints b, mytabs c, sysindexes d,=20
syscolumns e, outer syscolumns f
WHERE a.tabname=3Dlower(c.tabname)
AND a.tabid=3Db.tabid
AND b.constrtype=3D'P'
AND b.idxname=3Dd.idxname
AND a.tabid=3De.tabid
AND d.part1=3De.colno
AND a.tabid=3Df.tabid
AND d.part2=3Df.colno
drop constraint p_constrname
END FOREACH
On Feb 2, 2012, at 5:48 PM, Bill Hamilton wrote:
> Is there a super quick way to drop ALL referential constraints and =
indexes=20
> behind them?=20
>=20
> I would like to put all indexes into a space with a larger page size.=20=
> I wrote a program one time that consumes dbschema outut and writes sql=20=
> statements to drop and then add indexes.=20
> What I ran into was that when an index is dropped (one that I added =
before the=20
> constraints) the engine renames the index to=20
> a name of his choice and then the =93add index=94 fails because there =
is=20
> already and index on that column.=20
>=20
> The simplest approach appears to be to write a program to grab all the =
index=20
> adds and referential constraint adds and generate sql=20
> statements to *drop* all indexes and all constraints. Then, after =
running that=20
> sql just grab the part of the dbschema output that adds them=20
> and globally replace =93btree=94 with =93btree in idxspace=94 , save =
the file=20
> and run it through dbaccess.=20
> I suppose one of you gurus would hammer the syscontraints table, etc. =
I=92m=20
> too chicken.=20
> That part of the schema is about 4260 lines, so doing in an editor is =
not=20
> looking like a plan.=20
>=20
> So is there a better plan? Some magic Kagle unix script that I can =
convert to=20
> run through Windows?=20
>=20
>=20
> =
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **=
* * * * *=20
> =20=
>=20
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26181]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Feb 2012 12:12:09 EST
No. Your drag expression can contain a range of dates:
Art
On Feb 3, 2012 11:01 AM, "NATYURAL HORACIO" <horacio.natyural@gmail.com>
wrote:
> btw,
>
> there is no interval fragmentation in 11.1.
> so if i were to specify fragments per date, i'd have to specify all dates..
> in informix 11, does it allow fragmentation within the same tablespace?
>
> thanks
>
>
>
>
>
>
>
--e89a8f234cd3316c0404b81269f5
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26180]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Feb 2012 12:09:54 EST
Indexes get carried along if their fragmentation expression is compatible.
This works best if you can partition the table on a column that indicates
the period covered, like transaction date.
Art
On Feb 3, 2012 10:07 AM, "NATYURAL HORACIO" <horacio.natyural@gmail.com>
wrote:
> do i need to reindex if I do this?
> or will the indexes be applied.
>
> thanks
>
>
>
>
>
>
>
--14dae9340f9d6812d504b8126128
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26179]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Feb 2012 12:08:25 EST
Same idea, bad name.
Art
On Feb 3, 2012 10:03 AM, "NATYURAL HORACIO" <horacio.natyural@gmail.com>
wrote:
> oh this is nice.
> maybe what we need.
>
> is it equivalent to oracle's partition?
> or is it a different concept
>
>
>
>
>
>
>
--14dae9340f9d30fdd504b8125ac1
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26178]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Feb 2012 12:07:47 EST
Yes.
Art
On Feb 3, 2012 10:00 AM, "NATYURAL HORACIO" <horacio.natyural@gmail.com>
wrote:
> can i attach the fragment to another table?
> afterwards?
>
> Thanks
>
>
>
>
>
>
>
--14dae9399c1fc04d5c04b81258e5
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26177]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Feb 2012 12:06:37 EST
Then just attach the current table to the history table as a new fragment
then recreate the current records table empty.
Art
On Feb 3, 2012 9:46 AM, "NATYURAL HORACIO" <horacio.natyural@gmail.com>
wrote:
> PLEASE! Give us the full requirement and maybe someone will have an idea
> for you.
>
> hi really sorry bout that.
>
> - Do you need to move ALL of the rows out of one table and into new
>
> hitherto empty table ending with the first table empty?
>
> no, the other table is not empty. the other table is an existing table with
> the previous records in place.
> it's like a history table for the first table. what we are doing right now
> is
> renaming the table and then doing a union against that table. we don't
> want to
> incur too many unions.
>
> - Do you need to move ALL of the rows out of one table and intoan
>
> existing table with other data in it already ending with the first table
>
> empty?
>
> yes, we need to move all of the rows as much as possible into a table that
> has
> the data that was previously moved.
>
> - Do you need to do this for some of the rows in the table?
> nope, there's no particular selection needed.
>
> - What?
> sorry bout that lack of information.
>
>
>
>
>
>
>
--e89a8f22c681a89a5d04b8125515
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26176]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: paul@oninit.com (Paul Watson) - Fri, 03 Feb 2012 11:06:47 EST
No you can within the the same dbspace
> btw,
>
> there is no interval fragmentation in 11.1.
> so if i were to specify fragments per date, i'd have to specify all
> dates..
> in informix 11, does it allow fragmentation within the same tablespace?
>
> thanks
>
>
>
>
>
--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web: www.oninit.com
www.advancedatatools.com
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26175]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: horacio.natyural@gmail.com (NATYURAL HORACIO) - Fri, 03 Feb 2012 11:01:32 EST
btw,
there is no interval fragmentation in 11.1.
so if i were to specify fragments per date, i'd have to specify all dates..
in informix 11, does it allow fragmentation within the same tablespace?
thanks
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26174]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: horacio.natyural@gmail.com (NATYURAL HORACIO) - Fri, 03 Feb 2012 10:07:38 EST
do i need to reindex if I do this?
or will the indexes be applied.
thanks
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26173]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: victor.huaquisto@gmail.com (victor.huaquisto@gmail.com) - Fri, 03 Feb 2012 10:06:13 EST
Yes. The idea is the same... Regards.
On Fri, Feb 3, 2012 at 10:03 AM, NATYURAL HORACIO <
horacio.natyural@gmail.com> wrote:
> oh this is nice.
> maybe what we need.
>
> is it equivalent to oracle's partition?
> or is it a different concept
>
>
>
>
>
>
>
--
Saludos,
Víctor Huaquisto
--20cf3040ee1c1deb2c04b810a7c0
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26172]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: horacio.natyural@gmail.com (NATYURAL HORACIO) - Fri, 03 Feb 2012 10:03:30 EST
oh this is nice.
maybe what we need.
is it equivalent to oracle's partition?
or is it a different concept
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26171]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: victor.huaquisto@gmail.com (victor.huaquisto@gmail.com) - Fri, 03 Feb 2012 10:02:21 EST
Yes. It is easy and very fast.
On Fri, Feb 3, 2012 at 10:00 AM, NATYURAL HORACIO <
horacio.natyural@gmail.com> wrote:
> can i attach the fragment to another table?
> afterwards?
>
> Thanks
>
>
>
>
>
>
>
--
Saludos,
Víctor Huaquisto
--20cf3040ee1c34f26604b810993b
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26170]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: horacio.natyural@gmail.com (NATYURAL HORACIO) - Fri, 03 Feb 2012 10:00:34 EST
can i attach the fragment to another table?
afterwards?
Thanks
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26169]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Best way to move table contents to another
Posted by: horacio.natyural@gmail.com (NATYURAL HORACIO) - Fri, 03 Feb 2012 09:58:50 EST
just to expound,
we have this particular table, tbl_sample.
before, our script would delete and then insert it into another table. our
problem is this is taking too much time and it is reaching the time that the
system needs to open.
so what we did was to rename tbl_sample into tbl_sample_a and then did a union
in our queries.
our problem is, if there are too many unions, the performance also might
suffer.
so we were thinking, what is the best solution to move the tbl_sample into
tbl_sample_history for example.
if we can move all rows, it would be better.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26168]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
just to expound,
we have this particular table, tbl_sample.
before, our script would delete and then insert it into another table. our
problem is this is taking too much time and it is reaching the time that the
system needs to open.
so what we did was to rename tbl_sample into tbl_sample_a and then did a union
in our queries.
our problem is, if there are too many unions, the performance also might
suffer.
so we were thinking, what is the best solution to move the tbl_sample into
tbl_sample_history for example.
if we can move all rows, it would be better.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [26168]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
|
|
|
Subscribe to this feed
|
| You can subscribe to this RSS feed in a number of ways, including the following:
Drag the orange RSS button into your News Reader
Drag the URL of the RSS feed into your News Reader
Cut and paste the URL of the RSS feed into your News Reader
v
|
|
