Hi, few days ago I was do the Database Statistics and in the report I have some bad indexes, for example I have a field session which is represent a fiscal...
I want to migrate a Database from win1250 to utf8. If I change the encoding of the columns, the contents of these colums is still in in the win1252 encoding....
1. Take a backup of your database (nice to have) 2. Create a new field with the desired character set and commit 3. Copy the contents of the old field to the...
On client station i have local database with software requiring FB 2.1, on server is running FB 1.5. Is possible connect to server 1.5 via client 2.1 ?...
... 3. update mytable set newfield = cast (oldfield as varchar(x) character set utf8) where 'x' is the same size for both oldfield and newfield ./heLen...
... Usually such poor selectivity will make performance worse. Indices can only be of benefit if they eliminate the need to read data pages from disk. When...
Hello, I'll answer soon, I'm busy at the moment, sorry. Regards Olaf A large gap would result in a slower database, but results still ought to be correct....
Olaf Kluge
olaf.kluge@...
Feb 2, 2009 11:04 am
100030
Just to confirm a dude... What would happen if the change is made directly in the original field through IBExpert (i.e.). What about from NONE to WIN1252? And...
hmm, and how do you do with foreign key that have only very few value? cause foreign key automatiquelly create index ! thanks stephane ... have ... represent ...
Hi, ... You use some sort of 'trick' like: select <fields> from <table> where <some_indexed_condition> and your_integer_field_you_do_not_want_to_use_index+0 =...
I need to make a recursive SQL like this. My goal is to explode a recursive structure and mantain a depth dimensioni into field LIV without haveing a real...
... Gotcha!!! Thanks! Refresh the index statistics solved the problem. This is not automaticaly maded by FB? There´s a way to I do this in all index of the DB...
By the Way, Almost forgot... FB2.0.5 do not selected the best plan in my case... It is now selecting Plan: PLAN JOIN (P NATURAL, I INDEX (RDB$FOREIGN58), V...
Can anyone tell-me if this will run without damage my DB? FOR select RDB$INDEX_NAME from RDB$INDICES where RDB$INDICES.RDB$SYSTEM_FLAG = 0 into :MY_INDEX DO...
I´ve found this SQL by Fabiano almost like mine... But still don´t understand why FB do not do it automaticaly... set term !! ; create or alter procedure...
... This is indeed a limitation. Often the optimiser is smart enough to not use that index, but I have observed times when it still tries (particularly when...
... When and how often should FB automatically do it? Indices that are valuable *may* become less so over time, and vice versa, useless indices *may*...
... In this case, the index may not be so bad. Records in one year tend to be stored together, just because they tend to be created in the year that's in the...
Hey All - How do I go about using the services API with an embedded server? The reason I ask is that I need to be able to mark a database created by the...
Richard Wesley
hawkfish@...
Feb 2, 2009 11:47 pm
100042
We have a pool of more than 600 users accessing some FB 2.1.1 databases on a Open SUSE Linux server from different win32 apps (Delphi 7 and VB6). We have...
... This is an interesting question with some issues that I'm wrestling with myself at the moment from a different angle. However, with fbembed.dll or...
... my embedded applications can make multiple TIB_Connections to the database file each with separate identities. I see no reason why a simultaneous...
... That's interesting - and good to know. ... Yes - it *is* the issue for the action the OP was inquiring about. ... I wrote ... ...still holds. Particularly...
Hi, ... realy don't think so. fb clients (and servers) are very compatible between different versions. Anyway, make sure you use same version for client and ...
... No way. ... Most probably. ... No way ... Absolutely no way. ... No way. ... Very unlikely. ... Hardware faults. The fact that they appear at the same time...
Hi, Thanks Ann for help. I was created a lot of index like this and Firebird is use that indexes, just only in database statistics it is reported like "bad"...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
