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,
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
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
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
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
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
(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
--- 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
> 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
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
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-
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
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 :
--- 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
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
15 matches
Mail list logo