... Hi Set, Thanks for your reply. Here is my query which is a join between three tables. prdInCatTab holds the keys to product and prdCategory and it's a...
121761
homerjones1941
May 17, 2013 6:35 pm
Using GBAK via IBExpert, I get the following message. I don't know how to fix it (or find it). Overflow occurred during data type conversion. conversion error...
121762
haris_p_sw
May 17, 2013 6:44 pm
... Hi Ann, Thanks for your reply. I just posted an answer to Set: http://tech.groups.yahoo.com/group/firebird-support/message/121760 You can see there that I...
121763
Marcus Bajohr
marcus.bajohr@...
May 17, 2013 6:54 pm
Hej, are there any anormal entries in the firebird log? ... [Non-text portions of this message have been removed]...
121764
homerjones1941
May 17, 2013 7:44 pm
The most recent is pretty old, and doesn't seem to be related. HOMER-TOSHIBA (Server) Wed Feb 20 11:15:26 2013 INET/inet_error: read errno = 10054...
121765
Leyne, Sean
seanchk_98
May 17, 2013 7:54 pm
... I don't know myself, perhaps postgres applies a simple compression to the intermediate sort files to minimize disk space usage. The fact that your query...
121766
Leyne, Sean
seanchk_98
May 17, 2013 7:56 pm
... Run Gbak with verbose, it will identify the table which has the problem. Did you alter the data type/domain of any columns of the problem table? Sean...
121767
homerjones1941
May 17, 2013 8:13 pm
I now have more information. The problem is with only one Time field in only one record. I isolated it by executing the following query, which produced the...
121768
Alexandre Benson Smith
thoriblist
May 17, 2013 8:16 pm
... There are blobs in any of the tables ? Since you are using select *, any blobs will be returned. IIRC there is a memory consumition above the expected when...
121769
homerjones1941
May 17, 2013 8:25 pm
I ran verbose and found the table. But, being a novice, I did alter the data type. It had been a date field, and I changed it to a Time field. I thought...
121770
Ted Miglautsch
lyotchik
May 17, 2013 8:30 pm
Change it back and you should be fine....
121771
fabianoaspro
May 17, 2013 8:34 pm
Simple: do not touch system tables unless you know exactly what you are doing! This will avoid problems at all. There are no problems associated with reading...
121772
homerjones1941
May 17, 2013 8:35 pm
I'll try that. I'm worried about those users who have entered time values in that field after I changed from Date to Time. I'll test it and see. Thanks for...
121773
homerjones1941
May 17, 2013 8:42 pm
The application is in beta, and I suspect there may be other times when a change of domains is needed. Is there a way to do that without touching system...
121774
fabianoaspro
May 17, 2013 8:46 pm
When we need to change a field type we create a new field with the new type, move the old data to the new field and then drop the old field. Then You can...
121775
Ted Miglautsch
lyotchik
May 17, 2013 9:24 pm
I frequently make changes to system tables and started using Interbase and then Firebird because I could do that. Mostly I extent the size of char and varchar...
121776
Alexandre Benson Smith
thoriblist
May 17, 2013 10:16 pm
... The correct way of doing this is using a DDL command ALTER TABLE In future versions of FB directly system table updates will be denied. see you !...
121777
haris_p_sw
May 18, 2013 6:53 am
... Hi Set, Thanks for your reply. Yes, there are blobs and quite large varchar fields(160). I have already tested that if I select only some columns then the...
121778
haris_p_sw
May 18, 2013 7:36 am
... Hi Sean, Thanks for your reply. Yes. I know that select * doesn't help and I agree with you that the key here is the total size of the dataset to be...
121779
Alfonso Presa
alfonsopresa
May 18, 2013 8:14 am
HI, I'm doing a batch insert/updateon 2 tableswith around 1.2 millions records. After some time performance decreace drastically. I'm using that DB for Web...
121780
Mark Rotteveel
mark@...
May 18, 2013 8:18 am
... Although you specifically answer his question about why Firebird loads rows into memory, the problem described could also be a bug or a suboptimal...
121781
Thomas Steinmaurer
iblogmanager
May 18, 2013 10:57 am
... Run gstat -h against the database when things are getting slow. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services...
121782
homerjones1941
May 18, 2013 7:58 pm
Problem fixed. The solution was to change the domain from Time to varchar. Then, get rid of any values with a date format, leaving only valid time values. Then...
121783
Ann Harrison
annwharrison
May 18, 2013 10:56 pm
... Unless things have changed, blobs in a dataset are returned as eight byte blob ids, then fetched on reference, so the contents of blobs should not be in...
121784
stoneoldrock
May 19, 2013 8:13 am
Hi, all (and Vlad) I was here to ask help about BLOB, and it helped a lot. Now I have developed a function which can load multiple (different) files into...
121785
Kjell Rilbe
krilbe
May 20, 2013 6:53 am
Hi, Not sure this ever got posted before; trying again. I have a large FB 2.1 database, ODS 11.1. I previously had some problems with nbackup in 2.1 so I have...
121786
Stefan Heymann
stefanheymann
May 20, 2013 12:10 pm
Hi all, I am using UTF8 as the character set and the UNICODE_CI_AI collation. However, when I use the German "Sharp S" character (U+00DF LATIN SMALL LETTER...
121787
lcampbell
jlc6440
May 20, 2013 5:53 pm
Here's one I hope others have encountered (and possibly found an elegant solution). I have a table of constituents (which may be people or businesses) ...
121788
Norman Dunbar
normandunbar
May 20, 2013 6:48 pm
... I would be thinking of a SOUNDEX function for this. I need one myself to ensure that the "fat fingered" user - me - of my Music collection can type in a...
121789
Hannes Streicher
hstreicher
5:39 am
Hello All, ... Soundex has the advantage over other algorithms that the value to be compared can be precomputet and stored in the DB and the disadvantage that...