Hi All,
While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space
for the database the server crashed. See the attachment. Is it a known
limitation (not fixed in 2.5 because it's too old) or a bug?
Gabor
[Non-text portions of this message have been removed]
Hello all,
I ran an update query on a database with a computer and a notebook.
CPU's computer is Phenom 1075T, while notebook is i5 2557M.
Query is very simple, something like : update tbl set ln = 9;
Firebird on Computer is SS 3.0.3, on notebook SS 3.0.2, both runs on Windows
x64, both
Try looking for the Microsoft TZedit.exe utility. It is not installed with the
OS, but is an extended utility you can find on an OS disk (or used to)... There
are some exe copies posted around the internet (disclaimers …). It allows
view/edit of the time zones.
I don't think so.
When notebook speed to limit only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to calculate search for index.
I don't think so.
When notebook speed limit to only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to search for index.
Hi,your update query is disk intensive operation not CPU operation. CPU have
near to nothing here to compute.Regards,Karol Bieniaszewski
null
I don't think so.
When notebook speed to limit only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to calculate search for index.
Your last query update only one record then i cannot imagine how do you measure
this.But i have answered your question based on information provided. CPU can
be used in stricte calculations like a*b or e.g sort operations. To see simple
what do CPU in particullar database operation and if you
I don't think so.
When CPU speed on notebook limit to 0.8GHz process drop significantly.
Yes it was update only 1 record at the time.
But total records need to be updated is about 19.500.000.
So I made a small program that update 1.000.000 record and that's how the
calculation came out.
If only updated 1000 records at the time, the desktop runs faster but when it
reach 1.000.000
On 06/11/2018 17:07, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space
> for the database the server crashed. See the attachment. Is it a known
> limitation (not fixed in 2.5 because it's too old) or a bug?
Where
Hi,
We've been using Firebird "forever". For upcoming projects and also possible
replacement in existing ones, we're considering PostgreSQL.
What would you say is the pros and cons of Firebird vs. PostgreSQL?
I'm aware that the answers may very well be different depending on application
and
Firebird doesn't support schemas.
This is the main reason I am replacing it by PostgreSQL in all my projects.
In versions prior to 3.0, there is a limit on SQL instruction size, what
makes it hard to use with frameworks like Hibernate, which tends to
generate huge SQL instructions.
But this is
13 matches
Mail list logo