On 16-2-2013 20:57, Craig Cox wrote:
Firebird 1.5 Database on Linux
I have a database that appears to be running fine; however, when I try to
restore a backup from FB 1.5 (Linux) to FB 2.5 (Windows), none of the tables
show up in the restored database. I have completed similar restores
I have this simple select
select sum(apos.f_gewicht) as Gewicht
from t_apos apos
where COALESCE(apos.f_dat_anlieferung, apos.f_dat_erstellung) between
'2013-01-15' and '2013-01-16'
which does an natural scan on table t_apos although an index is on both
fields.
select sum(apos.f_gewicht) as
On Thu, Feb 14, 2013 at 4:12 AM, Ruben Marti la...@wanadoo.es wrote:
create table PRICES {
START_DATE date default current_date not null,
ITEM varchar(10) default '' not null,
PRICE double precision default 0 not null
};
alter table PRICES add constraint PK_PRICES primary key
On Sat, Feb 16, 2013 at 5:37 PM, ml600f ml6...@yahoo.com wrote:
i often need ranges in my program. Searching for bottlenecks i see that
BETWEEN is sometimes
very slow.
Use a separate index for each column that you use in a range query.
Firebird can combine ranges from separate indexes but
What are possible hosting providers that support Firebird? I have searched
older blog posts about Azure and Amazon but have found that it has not been
very smooth in the past. What is current situation? which VPS (Windows) or
cloud provider could be used?
[Non-text portions of this message have
Hi
We have a system running Firebird 2.5.2 where the HDD / system
performance periodically drops to pathetic levels. I have just
replicated the issue.
I backed up and restored a 4GB database. Doing a sweep of the DB prior
to this caused the HDD performance to drop to 1-2mb/s rather than the
What OS is hosting this setup? I suspect Windows 7.
Hi
You suspect correctly ! Windows 7 64bit
On 18/02/2013 11:31 a.m., Doug Chamberlin wrote:
What OS is hosting this setup? I suspect Windows 7.
Hello,
You can use any VPS with reasonable IO bandwidth.
Regards,
Alexey Kovyazin
IBSurgeon
What are possible hosting providers that support Firebird? I have searched
older blog posts about Azure and Amazon but have found that it has not
been
very smooth in the past. What is current
secondary index on ID,ADATE,NUMBER
First example (slow)
SELECT * FROM table
WHERE (ID BETWEEN 1000 AND 1000)
AND (ADATE BETWEEN '01.01.2013' AND '01.01.2013')
ORDER BY ID,ADATE,NUMBER
Elapsed time = 9 seconds resultset 8 records.
Plan shows firebird use correct index INDEX ID,ADATE,NUMBER.
I have this simple select
select sum(apos.f_gewicht) as Gewicht
from t_apos apos
where COALESCE(apos.f_dat_anlieferung, apos.f_dat_erstellung)
between '2013-01-15' and '2013-01-16'
which does an natural scan on table t_apos although an index is on
both fields.
select sum(apos.f_gewicht) as
11 matches
Mail list logo
