We have some Firebird databases which we have been running on a Linux server (databases ~ 500GB, 50 or so users, Firebird 2.1 Classic) Recently we have bought...
... They will fight for RAM, CPU and disk I/O. What is the worst - domain controller has write cache turned off (on system drive at least) which leads to poor...
I have MS Sql2008 running alongside FB 2.1 on 2 servers. Servers running Windows 2003R2 server. Spec of machines is 2 x Xeon with data on separate drives not...
Alan.Davies@...
10:07 am
106946
... Name confusion, apparently. MySQL has a utility called isql (probably .exe on Windows) and the jumble-up happens on POSIX platforms, not Windows. ./heLen...
... Looks like someone subscribed with a general helpdesk e-mail account which is imported to an issue-tracker. Mark -- GRATIS für alle GMX-Mitglieder: Die...
Mark Rotteveel
Avalanche1979@...
10:47 am
106949
Hi! I have a problem connecting to an old Firebird 1.0.3 Server. I use a connection string like the following "localhost:D:\someData.fdb". The connection takes...
... Firebird 1.0.3 was created long before Windows Vista saw the light of day. Who knows what kind of compatibility problems are lurking there. You might want...
Mark Rotteveel
Avalanche1979@...
12:16 pm
106952
Hi, I have an table which describes tree structure: CREATE TABLE TAB_Tree ( UID INTEGER PRIMARY KEY, Parent INTEGER REFERENCES TAB_Tree(UID), D...
hello, I update one row in 10 tables with a lot of index. (around 300 index to update) to insert or Update the data it is very fast (around 100ms) but, when i...
... Firewall? entry in the hosts file? ... You would be well advised to check whether this happens only to the first connection, or whether it affects every...
... AFAIK Indexes are updated during commit. You can do these steps: 1. Before a bulk load of a lot of records it's recommended to deactivate indexes and...
Milan Tomeš - Pos...
tomes@...
12:40 pm
106956
aie, and nothing can be change in the firebird.conf (memory optimization or write cache, or other) to speedup the process ? we have bi processor with 32 GO of...
... Vista Home probably throttles network services because it is not a Server OS. I have a customer that uses an XP machine (ouch!) as the Firebird server and...
... Not exactly, Windows XP (and maybe Windows Vista) only allow 10(*) half-open connections at a time (that is: connections where the handshake has not been...
Mark Rotteveel
Avalanche1979@...
1:36 pm
106959
... Ah, I haven't looked into that! In the meantime I switched to a windows XP machine, where the connection is made instantly. So it definitely has something...
... Not usually. If an index is active when a record version is created, the index will be updated immediately. That's pretty important. If the index updates...
Hi, Are there any recent changes/information regarding the above? i.e. I think it is more related to Windows OS but when a user bombs from an application...
I am having a real problem understanding & maintaining the interacting triggers and stored procedures in my DB. Because of poor coding I've got some serious...
... All I can guess is that you've got a huge (and uncontested) page cache, so until you commit, nothing goes to disk, then everything goes at once. If...
Hi, I've put together a really simple Survey Monkey survey asking about performance, page cache size, and lock table parameters. I'd appreciate your input. ...
I posted the following message about a week ago and have not received any response. Does anybody know what's happening here? Should I avoid using "ALTER INDEX"...
... Well, SET STATISTICS is much more efficient than ALTER INDEX. The former just reads the existing index and computes the selectivity. The latter deletes and...