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 us
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 n
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 suc
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.
http://www.firebirdsql.org/file/documentation/pap
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) h
> And how should I do my queries ? Is there some documentation for this ?
Yes. STUDY THE LANGUAGE REFERENCE !!!
> 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 * f
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-su
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
Sean
> 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 **separat
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"
Yes,
exactly this is what I wrote before !
Tiberiu
> 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 tempor
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.
Tiberi
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.
-
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 = 'MYINTEGER
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
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 ;
cr
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 desi
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 d
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 ever
21 matches
Mail list logo
