Please post the details of the table, including all indexes.



--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rich Pinder
Sent: 04 November 2005 15:50
To: Firebird
Subject: [firebird-support] FB 1.5 Slooooo / stalls large insert - Win2003
server


Hello again,

This is a follow up post after yesterdays 'Understanding ODS' thread.

I have an inefficient, iterative program that inserts data into a table
(200,000 records + ... committing after EACH one)
It works fine on my slow XP laptop develop machine.
After backing up / restoring on the production server (which brought it
up to ODS 1.1 - Thanks Alexandre), I tried again - and the process kind
of stalls at some point. Its odd, after running all night, it stalls
now at a mere 6000 records - yesterday it was kind of slowing at
around 30,000 or so after hours of running.

This morning I requested the database statistics, and it took
forever..but finally returned. I have the info saved if anyone suggests
reviewing a certain portion.

Here are some facts:

- I've tried running the 'app' both across the network and also from the
server machine itself
- server running Win2003 server (and is behaving in all other areas I
can see..nothing suspicious listed in the 'event viewer' etc)
- FB 1.5 remains running (thankfully) on the production server - I can
do selects against all the tables (including the one that seems to be
stalled, btw).
- memory and disk on server seems fine

Any thoughts of where to look next would be greatly appreciated.
Thanks
Rich Pinder
USC School of Medicine



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]