Re: [firebird-support] parrallel update - Email found in subject

2012-01-30 Thread Vander Clock Stephane
OK, i confirm the parametized queries it's MUCH MUCH more fast than normal query (up to 3x more fast!) Was a little "hard" to understand the api to know how to use well the parametized queries ... i do component for that to make it more simple to use (delphi) and call the query like update(SQL,

[firebird-support] Is our FB 2.5 Db corrupted ?

2012-01-30 Thread Colin
We have a 5GB Database FB2.5 Win2008 Server 4 Core M/C, 143 tables, problem with table INV 48K Records When everyone logs off and then log on, access to INV is slow for the last 7K Records. If we fetch all, it takes forever, but eventually can log off and log on again and all is ok. Same is OK

[firebird-support] batch script

2012-01-30 Thread Mahesh Pratihari
Hi All, Please guide me how to execute the batch script for a file, I have written in this way, could you let me know where is my fault, it showing error @echo off cls set SName=bg4ws0650 set UName=sysdba set Pwd=masterke set

Re: [firebird-support] Is our FB 2.5 Db corrupted ?

2012-01-30 Thread Alexey Kovyazin
Hello Colin, > We have a 5GB Database FB2.5 Win2008 Server 4 Core M/C, 143 tables, > problem with table INV 48K Records > > When everyone logs off and then log on, access to INV is slow for the > last 7K Records. If we fetch all, it takes forever, but eventually can > log off and log on again

Re: [firebird-support] Is our FB 2.5 Db corrupted ?

2012-01-30 Thread Thomas Steinmaurer
Hi Lawrence, > We have a 5GB Database FB2.5 Win2008 Server 4 Core M/C, 143 tables, problem > with table INV 48K Records Which Firebird architecture? > When everyone logs off and then log on, access to INV is slow for the last 7K > Records. If we fetch all, it takes forever, but eventually can

[firebird-support] when an index is needed ?

2012-01-30 Thread Vander Clock Stephane
Hello, From with amount of record in a table it's start to be usefull to have an index ? 100? 1000? 1 ? Actually i thing about 200 ? maybe 1000 ? ie : for query like select ... from ... where order by thanks by advance stéphane

[firebird-support] gbak connection string

2012-01-30 Thread Sergio H. Gonzalez
(FB 2.5) Hello! is there any problem in using gbak with this string: gbak c:\myfolder\mydatabse.fdb [etc...] while there are other PCs connected to the same databse with tcp/ip: servername:c:\myfolder\mydatabse.fdb ??? If I remember well, mixing string connections could damage the database? I

[firebird-support] Re: last record from a table

2012-01-30 Thread Sergio
--- Alexandre Benson Smith wrote: > I would go for: > select first 1 MyDate from MyTable order by ID desc > With a descending index on ID of course. Thanks Alexandre! I tried both and your method seems to be better... There's a slight difference in the statics. mine: Reads from disk to cache

RE: [firebird-support] when an index is needed ?

2012-01-30 Thread Leyne, Sean
> From with amount of record in a table it's start to be usefull to have an > index > ? > 100? 1000? 1 ? > > Actually i thing about 200 ? maybe 1000 ? Adding an index is not about the number of rows/records, it is about the "uniqueness" of the index. Consider, A table with every person i

[firebird-support] Sweep interval : OST - OIT OR OST - OAT ?

2012-01-30 Thread Vander Clock Stephane
Hello, when i read this doc http://www.ibphoenix.com/resources/documents/general/doc_67 The automatic sweep is kicked off when the difference between the OAT and the OST is greater then the sweep interval but when i read this : http://www.firebirdnews.org/?p=4475 The automated sweep will start

[firebird-support] Access a Firebird database on another LAN Computer

2012-01-30 Thread chervenokos
Hello, I am trying to connect a Firebird database, that is located on another LAN computer via my Delphi-programm. When tha database is on the same computer, there is no problem and the the Delphi-programm connects successfuly and the programm works fine. I do try the following syntax for LAN-

Re: [firebird-support] Sweep interval : OST - OIT OR OST - OAT ?

2012-01-30 Thread Carlos H. Cantu
VCS> What is good answer ? FBNews is the correct, and the reasons are explained in that post. A lot of articles (and even books) around are incorrect regarding this subject. VCS> also what is OIT? isc_info_oldest_transaction or isc_info_oldest_active ? OIT = Oldest Interesting Transaction = the

Re: [firebird-support] Sweep interval : OST - OIT OR OST - OAT ?

2012-01-30 Thread Michael Ludwig
Vander Clock Stephane schrieb am 30.01.2012 um 23:43 (+0400): > when i read this doc > http://www.ibphoenix.com/resources/documents/general/doc_67 > > The automatic sweep is kicked off when the difference between the OAT > and the OST is greater then the sweep interval > > but when i read this :

[firebird-support] Re: Access a Firebird database on another LAN Computer

2012-01-30 Thread karolbieniaszewski
--- In firebird-support@yahoogroups.com, "chervenokos" wrote: > > Hello, > I am trying to connect a Firebird database, that is located on another LAN > computer via my Delphi-programm. When tha database is on the same computer, > there is no problem and the the Delphi-programm connects succes

Re: [firebird-support] Access a Firebird database on another LAN Computer

2012-01-30 Thread Magnus Titho
Am 30.01.2012 20:33, schrieb chervenokos: > I do try the following syntax for LAN-connection: > 192.168.1.2:C:\Users\emo\!EMIL\DB\SOSIFB214.FDB > but the connection fails .. My guess: You haven't installed Firebird on the other computer (192.168.1.2). -- Magnus