Sort of on topic, how many foreign keys in a single table is good v.
bad? I realize it's relative to the tables the FK's reference so here's
an example:
Table A: 300 rows
Table B: 15,000,000 rows
Table C: 100,000 rows
Table E: 38 rows
Table F: 9 rows
Table G: is partitioned on the FK from Table A
Solved, it turned out to be a lock caused by a gui connected to the
database, even though the gui wasn't actually doing anything at the time...
Sue
Stephan Szabo wrote:
On Thu, 10 Aug 2006, Sue Fitt wrote:
Hi all,
This is my first post to the performance list, I hope someone can help me.
Hi,
On Thursday 10 August 2006 12:00, Phil Cairns wrote:
| In fact, the information is going from the
| server to the client machine at dialup speeds over a 100 Mb LAN to some
| machines, and full speed to others.
[...]
| There are no problems with copying files across the network.
and you are re
Hi, Phil,
Phil Cairns wrote:
> Has anyone experienced this sort of thing before? We're running with
> 8.0.4. My application uses libpg, while another application is using
> OLEDB. Both the native and OLEDB layers exhibit the delay on the "slow"
> machines, and have no problems on the "fast" machi
Hi, Hansell,
hansell baran wrote:
> When we run the following query "SELECT * FROM big_table", we get the
> following resutls:
Just for Curiosity:
Could you try to "COPY big_table TO stdout" from psql[.exe]? (and
possibly redirect the psql output to /dev/null or so?)
> Is there a way to increa
Hi, Eldhose,
contact1981 wrote:
> I am trying to migrate data from a DB2 database to SQL Server 2005
> database. Does anyone know about any migration tool that does that? I
> have heard about DB2 Migration Tool kit, but I think you can only
> migrate data to a DB2 database with that. Thank you
Hi, Jim,
Jim Nasby wrote:
> Your biggest win would be to batch those inserts together into
> transactions, if possible.
Using COPY instead of INSERT might even give better wins, and AFAIK some
client libs use COPY internally (e. G. tablewriter from libpqxx).
> If not, the commit_delay settings
