Ok so i have this query, I want the customset.info to show a blank value for a part number. but when i set the customfieldid to 51 the record does not show...
Sorry guys, But i was able to resolve the issue. I had to take the line customfieldid = 51 and join in with customset.recordid = part.id and customfieldid =...
Hi, I experiencing a performance problem on some windows machines that i tracked down to gds_prepare using Intel's vtune. On some machines a sample program...
... Hi Haris! I've no clue about your actual question, but am curious as to what your query looks like and what size of tables and result sets we're talking...
... Firebird actually doesn't sort whole rows, it sorts only the rows requested in the query - so select * is your enemy here as well. If it were to sort ...
... 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...
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...
... 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]...
... 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...
... 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...
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...
... 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...
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...
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...
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...
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...
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...
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...
... 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 !...
... 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...
... 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...
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...
... Run gstat -h against the database when things are getting slow. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services...
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...
... 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...
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...
