RE: [firebird-support] Digest Number 9396

> I do not declare domains. But you could! With just a little effort on your part. Take a little time, do the following: CREATE DOMAIN D_INTEGER AS Integer; CREATE DOMAIN D_Varchar_20 AS VARCHAR( 20); Then when you create your temporary tables just make 2 minor changes: create global

RE: [firebird-support] Digest Number 9396

Yes, exactly this is what I wrote before ! Tiberiu

RE: [firebird-support] Digest Number 9396

Dmitry, > 21.11.2016 16:22, tiberiu_horv...@yahoo.com [firebird-support] wrote: > > Hope this is all right now . > >No. The idea to create temporary tables on the fly and then drops them is > completely wrong for Firebird. "Wrong" is really not the correct word for this case. "Sub-optimal"

RE: [firebird-support] Digest Number 9396

> 1. I create those temporary tables for one user only, for one transaction > only, > not visible for other users. I keep a track (log) of those tables and delete > when I exit the program (drop table). All of that is already supported by temporary tables -- each connection creates a

RE: [firebird-support] Digest Number 9396

The performance of the query may have been a function of the query approach itself, not the presence of the index From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, November 21, 2016 1:19 PM To: firebird-support@yahoogroups.com Subject: RE:

[firebird-support] tracker.firebirdsql.org and web.firebirdsql.org will be offline Tuesday November 22 from 20:00 to 24:00 EST

Sean

RE: [firebird-support] Digest Number 9396

I tested the query on a big database. It was faster if I disabled the index. Tiberiu ---In firebird-support@yahoogroups.com, wrote : > 2. the use of index is deliberately blocked, I want to do it this way, my > query > is faster. "Blocked" why? Sean

[firebird-support] Firebird 2.5.6 Newbee question

I am new to Firebird. I have downloaded Firebird 2.5.6 (Client, Classic Server and SuperServer versions) but when I install them on my MAC, I cannot find any files even though my MAC tells me that the programs have been successfully installed. I am running OS 10.9.5 (Mavericks, I believe)

Re: [firebird-support] Firebird 2.5.6 Newbee question

21.11.2016 20:48, ratdog1...@msn.com [firebird-support] wrote: > I simply want to try and use the open-source software to create some da > tabases. I am > moderately experienced in SQL, having used both Oracle and Microsoft Access > in the past.

Re: [firebird-support] Firebird 2.5.6 Newbee question

Tuesday, November 22, 2016, 8:48:05 AM, ratdog1...@msn.com wrote: > I am new to Firebird. I have downloaded Firebird 2.5.6 (Client, > Classic Server and SuperServer versions) but when I install them on > my MAC, I cannot find any files even though my MAC tells me that the > programs have been

[firebird-support] Re: Best way to delete millions of rows

Hey I have finally had some more time to look into the problem I have been having, and have isolated and reproduced the problem. The cause of the problem seams to be a Varchar(36) ID column containing a guid/uuid. Steps to reproduce: 1) Create a table(TEST) with a single varchar(36) column

Re: [firebird-support] Digest Number 9396

All right, thank you all for your time ! I have code that uses temporary tables in at least 30 places in my programs. This is the way I did complicated queries. Most of these procedures are written 10 years ago (Interbase, Firebird 1.0). I cannot change everything (replace every query that

Re: [firebird-support] Digest Number 9396

1. I create those temporary tables for one user only, for one transaction only, not visible for other users. I keep a track (log) of those tables and delete when I exit the program (drop table). The temporray table name is generated randomly 'TEMP_TABLE_' + . 2. the use of index is

Re: [firebird-support] Digest Number 9396

21.11.2016 12:08, tiberiu_horv...@yahoo.com [firebird-support] wrote: > My problem is that when I create those tables, this automatic domain > declaration declares > (creates automatically) "huge" domain names (saw these with IBExpert, setting > system > domains visible). Bad application

Re: [firebird-support] Digest Number 9396

So, everytime I create a table in FireBird, a new domain is created automatically in the database ? This surely could be an explanation of my problem ! I will try to create domains and use those in DDL . Is this a correct approach : create domain MyIntegerDomain Integer ;

Re: [firebird-support] Digest Number 9396

Yes, But the new domain is not created for every table, just for every column where you are not using a pre-defined domain. So, Create table MYTABLE(mycolA integer, mycolB integer, mycolC integer); would auto create three separate new domains. I wish I knew more of what you are trying to

Re: [firebird-support] Digest Number 9396

I understand. And I saw that when I drop the temporary table these auto generated domain names disappear but the generated names keep on "growing" . I modified my routines so that : I verify if I have the domain SELECT * FROM RDB$FIELDS where RDB$FIELD_NAME =

Re: [firebird-support] Digest Number 9396

And how should I do my queries ? Is there some documentation for this ? I need to compile data from several tables, scan the records, update , delete some and then prepare the data for a report. For me the with query as( select ) select * from query is not enough.

Re: [firebird-support] Digest Number 9396

21.11.2016 16:22, tiberiu_horv...@yahoo.com [firebird-support] wrote: > Hope this is all right now . No. The idea to create temporary tables on the fly and then drops them is completely wrong for Firebird. -- WBR, SD.

Re: [firebird-support] Digest Number 9396

Monday, November 21, 2016, 8:37:50 PM, tiberiu_horv...@yahoo.com wrote: > This is how I create my temporary tables : > create global temporary table TEMP_112233 > ( > id : INTEGER, > name : CHAR(20) > ) > on commit preserve rows You should create your GTT only once in your life, not