... quoted ... The setting in the DNS is not important until you indeed HAVE quoted identifiers in your database; for that you must yourself CREATE them first....
... Could it be due to file system backup or virus scanning at the time you try to connect to the database (or worse, a restore taking place)? Just a wild...
Thank you for the link to the archive. And sorry for posting the same question again. I hope that future version of firebird will come with better performance...
Hi David, ... As you're using 1.5 you can write a stored procedure to do it... CREATE PROCEDURE SYS_RECALC_SELECTIVITY AS DECLARE VARIABLE INDEXNAME CHAR(31); ...
Dear All, How to delete the output of this "select first 100 seqno from repl_log where relationno =11 order by seqno" Doind this:- "delete from repl_log where...
Mohd. Jeffry
linuxlah@...
Jun 1, 2005 8:54 am
61113
... The problem is the multigenerational architecture. There may exist several versions of the same record and only one of those versions will be visible to...
... Because the subselect is executed once for every row, and when you execute it for the 50th time records 50 through 149 will be the first 100. ... I think a...
... Deletion becomes recursive; I'd suggest stored procedure with something like while counter < 100 select first 1 keys from repl_log order by seqno into ...
... this would be recursive too no? the select fires after every delete. You need to completely separate the listsof IDs from the delete operation Alan...
... 1. Not very efficient: delete from repl_log r where 101 > ( select count(*) from from repl_log r2 where relationno = 11 and r2.seqno < r.seqno) 2. Use a...
Hi We have had the same demands and solved them with drbd (http://www.drbd.org) It works on Linux, for windows i don't know. It's running for a year now and...
Bogdan
bogdan@...
Jun 1, 2005 9:45 am
61119
Hi, ... Ideally, you would use a middle-tier layer that does load balancing and fail-over safety. I can't give you any ideas, since you didn't mention what was...
... I know that IBO (for Delphi and Borland C++) has both TIB_Cursor (unidirectional) and TIB_Query (bidirectional). Though I do not know how this is done...
... As far as I know Firebird is forward only and all bidirectional stuff is done at the client. With regards, Martijn Tonies Database Workbench - tool for...
... statistics, ... here ... performed ... slower to ... order ... read it ... and ... OK, here's the info you requested: (NOTE: This is now on version 1.5.2,...
Hi, ... Also BLOB fields? ... Store_No contains a lot of duplicates, is the index really needed? ... Set Page buffers to the number you want FB to use as...
... does this mena you have declared PK contraints AND added a separate index? in which case you are defeating the optimiser. PK constraints already have ...
... Drop the index on Store_No, the selectivity is too poor for the index to be useful (your GROUP BY query should execute somewhat faster without this index,...
... No, he said that (SKU, STORE_NO) constitutes a PK. The GROUP BY 1 is obviously a typo, probably because he was experimenting with variations of the query...
... And why doesn't FB automatically ignore an index with such bad selectivity in this situation? Is there *any* situation where this index should actually be...
... I'm allowed to assume, write my assumption in my reply for him to confirm that my assumption was right, and based on that assumption give him a helpful...
Pavel, ... What would the command line look like for a 'local connection'? I currently use gbak -c <backup file> <server:restore file> I tried changing...
Hi! At work, some computer works and some others don't. I just changed the database to Firebird (I am using Access) When trying to change data, some user get...
The Third Firebird Worldwide Conference will take place at the Hotel Olsanka in Prague, Czech Republic. The opening session will be on Sunday evening, 13th...
... Pavel's comment isn't applicable to CS on Windows. (I checked backed to an earlier message of yours, where you stated "I'm running FB 1.5 classic on a ...
Hi, ... Yes, there are certainly cituations where the index does help. When a field contains only 2 values, but 1 value is in only 1% of the records. For...
