On 22/11/16 07:09, tiberiu_horv...@yahoo.com [firebird-support] wrote:
> 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 everyth
Do you see the same behavior if the guid field is not indexed?
> On Nov 22, 2016, at 3:09 AM, tiberiu_horv...@yahoo.com [firebird-support]
> wrote:
>
>
>
> 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
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
> 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
-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<mailto:firebird-support@yahoogroups.com>,
mailto:Sean@...>> wrote :
> 2. the use of index is deliberately blocked, I want to
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
> 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
@yahoogroups.com
Subject: 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
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
This is how I create my temporary tables :
create global temporary table TEMP_112233
(
id : INTEGER,
name : CHAR(20)
)
on commit preserve rows
I also do some create views :
CREATE OR ALTER VIEW CAUT_PRODUSE_VIEW_4982590
(
COD_PRODUS,
ID_PRODUS
)
AS
selec
t you in touch with a
> FB specialist in your area.
>
> best regards
>
> Dalton
>
> From: firebird-support@yahoogroups.com on
> behalf of tiberiu_horv...@yahoo.com [firebird-support]
>
> Sent: November 19, 2016 9:12:59 AM
> To: firebird-support@yahoogroups.com
ebird-support@yahoogroups.com
Subject: Re: [firebird-support] Digest Number 9396
I use only
CREATE TABLE and DROP TABLE metadata commands in runtime. I populate
the tables and that's all. I don't create domains, not at all.
I use FB 3.0 on a Linux server (I don't maintain
OK, but if gbak backups this domain name , shouldn't it restore it also ?
Tiberiu
---In firebird-support@yahoogroups.com, wrote :
The RDB$ domains are auto generated by the system - RDB$1297080260861 says
that it is the 1,297,080,260,861 domain created by the system.
I use only
CREATE TABLE and DROP TABLE metadata commands in runtime. I
populate the tables and that's all. I don't create domains, not at all.
I use FB 3.0 on a Linux server (I don't maintain that server) .
The database file is very big - 1+ GB in size, my customers append arround
lf of tiberiu_horv...@yahoo.com [firebird-support]
Sent: November 18, 2016 5:43:56 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Digest Number 9396
Thank you for your answer,
"You have data in your column in that table that no longer fits in the new
definition"
Thank you for your answer,
"You have data in your column in that table that no longer fits in the new
definition"
The data in a table that uses one of those domains has only one record, I do
not alter that record at all (some document type name default defined).
I create many tempora
groups.com
Subject: Re: [firebird-support] Digest Number 9396
Support for Users of Firebird ReleasesHi all,
I have a FireBird 3.0 server on a Linux machine, at a customer who appends
arround 3000 records / day in some tables. I have a strange problem that
keeps me from performing normal backup
Support for Users of Firebird ReleasesHi all,
I have a FireBird 3.0 server on a Linux machine, at a customer who appends
arround 3000 records / day in some tables. I have a strange problem that
keeps me from performing normal backup / restore operations. In the database
there are some huge doma
27 matches
Mail list logo