Dear Group, I know that you can put an index on a single column and on multiple columns at the same time. But you can also put a separate index on each column...
Zd
toldy007@...
Jul 1, 2008 7:50 am
95367
Indexing the two columns within the same index, is a little bit faster when your search specifies both of them - if you use partial match like BETWEEN or...
... Hi, Firebird will use your compound indexes if you search for single columns, so I guess it doesn't matter what approach you choose. There might be some...
Sorry, forgot to mention why I generally prefer single field indexes: It makes it easier for me to understand the PLAN that Firebird suggests. With a compound...
Hi , i use fb 2.0 and i have a field its type is varchar how long it can to be ? i mean whats the limit for varchar at the 2.0?how many charachter i can write ...
I was reading this article from Ann Harrison http://www.ibphoenix.com/main.nfs?page=ibp_expert1 This particular section is interesting Index optimization ...
I just came across this by accident, and you may not be interested anymore, but: http://www.firebirdfaq.org/faq334/ FB1.0, and it doesn't mention if it's...
... It turns out that they only use ODBC on a restored DB copy - so not the answer. ... I dont mind if they can access the data - it belongs to them - I just...
... Yes - and it doesnt fix it. In fact I can login remotely and get the same error as the client. Only when I delete and recreate the permissions, then ...
Niben, ... It is very necessary! It just isn't always necessary. ;-] It depends on: - number of unique elements which are fields to be indexed - number of rows...
Hi, I just download and install the latest FirebirdCS-2.1.0.17798-0.i686.tar.gz under my Debian 3.1, the install.sh works fine. But after the installation, I...
... FB CS uses xinted to listen on. see you ! -- Alexandre Benson Smith Development THOR Software e Comercial Ltda Santo Andre - Sao Paulo - Brazil ...
... 32KB If you have a variable length field the BLOB's are the way to go. see you ! -- Alexandre Benson Smith Development THOR Software e Comercial Ltda Santo...
I am attempting to restore a FBK backup file that was from a Linux system, but on a Windows computer (both running Firebird 1.5.5). When I go to restore the...
Hi all, I write my apps in D2007 with Firebird server. One of my customers has 2 PCs, Windows XP home edition. One PC has Firebird 2.03, the other one runs the...
Hi Myles! Maybe a stupid question, but when the backup was made, was the -nt (non-transportable) switch specified? The default should be the -t (transportable)...
I got exactly this message trying to backup from a FB 2.1 server with a FB 2.03 gback. Tiberiu From: Myles Wakeham Sent: Wednesday, July 02, 2008 4:04 PM To:...
Hello, A customer of mine decided to change the working scheme. Now all the clients PC connect to the server via Terminal Server and runs my app localy in the...
... Windows 1.5.5 services manager restore code thinks it's looking at a backup made on Fb 2 or higher. Are you absolutely certain it's not? ./heLen...
... Only if you search the *first* columns. For example, if you have compound index on (A,B) and you search WHERE B = 10, it will not use it. -- Milan Babuskov...
... backup made on Fb 2 or higher. Are you absolutely certain it's not? No, the server that I originally had this problem on is a Fedora Core 5 Linux box that...
... (non-transportable) switch specified? The default should be the -t (transportable) switch, so it doesn't sound like something normally done by mistake... ...
... Thanks for the suggestion. I didn't specify the switch, however when I tried to restore using IBExpert in verbose mode, it stated that the backup file was...
... with a FB 2.03 gback. I know that the original server where the data was backed up from only has ever had FB 1.5 installed on it. And its GBAK is the...
Of course I use FB 2.1 official installer. Firebird-2.1.0.17798_0_Win32.exe I had no problems on any of the PC-s that I installed FB 2.1 to. Is this ...
... Check following : a) you have no msvc8 runtime libraries in system32 b) you have no msvc8 runtime libraries without manifect in your app folder c) you have...
I am receiving a huge amount of messages with the following text: ReadFile end-of-file errno = 109 I am using Firebird 2.1 on Windows 2003 Server Standard...
