Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 23, 2015, at 1:06 AM, SUKHEN DASS sukhend...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. First, you've hijacked a thread, which is not considered

Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, 1. Is this VB exe or web? 2. Save all insert statement parameters to tabbed csv and you will see at what statment it stop. If this is always at the same statement, then compare it e.g. in excel withprevious statements. Regards, Karol Bieniaszewski - Reply message - Od: SUKHEN

Re: Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
its not always at same insert statementhang insert statement varies On Wednesday, February 25, 2015 12:27 PM, SUKHEN DASS sukhend...@yahoo.com wrote: its a window base app using vb.net... i will definitely try your suggestion On Wednesday, February 25, 2015 11:48 AM,

Re: Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
its a window base app using vb.net... i will definitely try your suggestion On Wednesday, February 25, 2015 11:48 AM, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com wrote:  Hi, 1. Is this VB exe or web? 2. Save all

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-23 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Many thanks for your comments! Thomas -- Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604 Mail thomas.beckm...@assfinet.de mailto:thomas.beckm...@assfinet.de ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 •

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-22 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.But inside the loop while executing ExecuteNonQuery control does not come back

[firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-20 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
20.02.2015 17:36, Thomas Beckmann wrote: I wonder whether this still holds true, 'cause reading in current how tos and web pages even on firebirdsql.org makes me assume sweeping and garbage collection are the same today. They're still different beasts. I'm wondering what pages say the

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-20 Thread Nick Upson n...@telensa.com [firebird-support]
so if I run gbak -g every night I should also run gfix​, but if I run gbak without -g I don't need gfix (but it helps a little) ? Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 20 February 2015 at 18:36, Ann

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Thomas, Gbak backup removes all unnecessary back versions and all rolled back changes, unless it is run with the -g switch. That switch is provided for those cases where a database cleanup is not needed. Examples include the case when the database will immediately be replaced by a restored