] Project1.dpr(14): H2077 Value assigned to 'x' never used
(Line 14 is the one assigning zero.)
On Thu, 09 Feb 2017 04:30:06 -0500 *Tim Ward t...@telensa.com
[firebird-support] <firebird-support@yahoogroups.com>* wrote
It' the equivalent in a conventional programming la
te the *intent* of logic.
That is completely outside the purview of any application
environment that I know.
The only thing that a system can check/enforce is the correctness
of the code, not to check whether the developer has 2 brain cells.
Sean
--
Tim Ward
some number which you can't tell by
looking at it whether it's right or not.
--
Tim Ward
fun when one of your production databases has
patterns of data that weren't included in your test data sets.
--
Tim Ward
On 13/01/2017 14:04, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote:
>> I just don't believe this. Can anyone make any other suggestion as to
>> what is going on?
> Is timezone on your
ometimes the UK time.
I just don't believe this. Can anyone make any other suggestion as to
what is going on?
On 13/01/2017 11:21, Tim Ward wrote:
> On 12/01/2017 14:09, Tim Ward wrote:
>> Sorry if this is a really basic question, but some time spent
>> searching has failed to
On 12/01/2017 14:09, Tim Ward wrote:
> Sorry if this is a really basic question, but some time spent
> searching has failed to find for me the definitive detailed
> documentation on exactly how Firebird handles time zones (I'm
> particularly interested, to start with, in using CURRE
, and later reading it out and using it to display in a UI, but
that's only to start with).
Can someone point me in the right direction please?
--
Tim Ward
05.01.2017 14:40, Marianne Castel - Titelive caste...@titelive.be
[firebird-support] wrote:
> Has somebody an idea, where is the sytem loosing time ?
Most often (x)inetd waste time trying to identify client by ident
protocol or reverse DNS to get host name.
--
WBR, SD.
--
Tim Ward
cond delay before data got flushed to disk, as an
optimisation in case you were just about to write something else. (Which
could, once you'd discovered what was going on, which might take a few
days or weeks, be turned off.)
I don't however expect to see exactly the same problem with Firebird 3 .
a commit it'll quite likely all be in one
transaction which can produce the symptoms you describe.
--
Tim Ward
... but having restored the database from backup the problem appears to
have gone away.
On 12/07/2016 12:52, Tim Ward wrote:
There was plenty of space on the disk partition containing the database.
But there had at some point been a disk full on some other partition.
So, having run out
partition filled up.
On 12/07/2016 12:50, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
W dniu 2016-07-12 11:54:52 użytkownik Tim Ward t...@telensa.com
[firebird-support] <firebird-support@yahoogroups.com> n
when run
against a 64 bit 2.5 database. What's going on please?
--
Tim Ward
circumstances - that's not terribly helpful
if all the process names are "python" and all the IP addresses are
"127.0.0.1", for example.
--
Tim Ward
rent users. This means that
poking around in the database to see what's going on (performance,
long-lived transactions, etc) is a bit easier - we can instantly see
which process is doing what, as the users are named after the processes.
--
Tim Ward
on existing connections, or something?
--
Tim Ward
, so if we poke around in the database we can
see at least which part of the system any problematic (eg very long
running) user sessions or transactions or queries belong to.
--
Tim Ward
and restore process)
B. table will be 100GB and in db will be 100GB free pages? (db size
will be 300GB and i need to bakup and restore?)
what is the answer for this A or B?
regards,
Karol Bieniaszewski
--
Tim Ward
e possibility of
machine-generated code they might have reached a different decision
about the second parameter, or even the first, being mandatory?)
I'm just pointing out the typo in the book - there's no closing square
bracket in that definition.
st checked that
it doesn't exist, which it doesn't as far as transaction B is concerned,
because transaction A hasn't committed yet)
results in the error.
Have I remembered this behaviour of primary keys correctly? Please could
someone remind me where the documentation is if so?
--
Tim Ward
- there's no overhead because
there's no concept of doing anything without a transaction.
--
Tim Ward
an characters, like ş and ţ.
As far as I can see, those characters do not exist in the Windows 1251
character set, so isn't the error message simply telling the truth?
--
Tim Ward
*is*
a potential performance problem, I imagine I can get rid of it simply by
doing "ibase_commit();" at the start of the PHP script?
--
Tim Ward
gbak:adjusting an invalid decompression length from -33 to -19
gbak: ERROR:value exceeds the range for valid timestamps
gbak: ERROR:gds_$send failed
gbak:Exiting before completion due to errors
Anyone any idea what any of that means?
--
Tim Ward
versions of the library called by the UDF.)
--
Tim Ward
htly different output and will not be researching it any further.
--
Tim Ward
tion event?
Thanks
--
Tim Ward
but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a simple table with
> less of 5.000 rows!
>
> What i can do?
What are your queries, query plans, quer
e database, partly
direct queries and partly stored procedure calls, as well as user
interface accesses via PHP. (Oh, and possibly some Python processes and
other stuff, but it's the interaction between a couple of the C/C++
processes that is currently confusing us.)
--
Tim Ward
d, as vast
numbers of other tools understand it), you can add whatever custom
resources you like.
--
Tim Ward
("resource") and you're /supposed/ to use it properly.
Pity this doesn't apply portably to all file types, innit.
--
Tim Ward
Thanks for the replies.
Don't worry folks, I'm not going to try this, I was just curious.
Yes I do know it's not a real deadlock, I was using the word because I
knew it would be understood and because, I'm pretty sure?, I've seen it
in one of the relevant error messages.
--
Tim Ward
no reason why this shouldn't work, as either way the
record is going to end up deleted, which is what the user wants, but
would I be right in guessing that Firebird isn't that clever, and that
deadlocks are possible in this scenario?
--
Tim Ward
with this error. Restart it, and it runs fine. Until
the next time.
--
Tim Ward
on-text portions of this message have been removed]
--
Tim Ward
a similar question some time ago but didn't end up with
any actual diagnosis of our problem.)
--
Tim Ward
++
Visit http://www.firebirdsql.org and click
,
Thanks for the reply. You mentioned that you did it with a logging
procedure. Can you share what you exactly what you did to accomplish
this?
Mike
--
Tim Ward
[firebird-support] wrote:
Greetings All,
Firebird 2.5.4
I would like to know if there is any way that I can retrieve the
execution time of each SQL SELECT or EXECUTE PROCEDURE within a stored
procedure?
Any tool to accomplish this?
Thanks,
Mike
--
Tim Ward
f the user, remember) are ASC and some DESC?
I think we'll have to continue to think about it!
On 06/10/2015 21:50, setysvar setys...@gmail.com [firebird-support] wrote:
Den 06.10.2015 17:38, skrev Tim Ward t...@telensa.com [firebird-support]:
> Given that a query needed to return data for a p
of the user, remember) are ASC and some DESC?
I think we'll have to continue to think about it!
On 06/10/2015 21:50, setysvar setys...@gmail.com
<mailto:setys...@gmail.com> [firebird-support] wrote:
Den 06.10.2015 17:38, skrev Tim Ward t...@telensa.com
<mailto:t...@telensa.com> [fire
have to
do in the UI). In, that is, a sane amount of time - fetching hundreds of
pages of data to the grid sequentially until the right record appears is
not a reasonable solution! ID may or may not be the primary key, but we
can use an indexed unique field if that helps.
--
Tim Ward
(millions of times slower if you're
really lucky). If that's your situation you may be better off deleting
and recreating.
--
Tim Ward
possibilities? I must say that
Oldest transaction390433636
Oldest active390433637
Oldest snapshot390433637
Next transaction391092651
doesn't look too encouraging, so I'd better investigate that.
--
Tim Ward
) and sort
the results
Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
On 9 September 2015 at 13:00, Tim Ward t...@telensa.com
<mailto:t...@telensa.com> [firebird-support]
<firebird-support@yahoogroups.com
<m
of approach, that's needed for other
reasons anyway, which eliminates the problem query.)
--
Tim Ward
* system using *any* tools is pointless
if you don't do regular test restores.
--
Tim Ward
getting such plan:
PLAN JOIN (T1 NATURAL, T2 INDEX (FK_TABLE_2))
Why in case of TABLE_1 optimizer did not chose index PK_TABLE_1? And
why I am getting error when i try to enforce it with:
PLAN JOIN (T1 INDEX (PK_TABLE_1), T2 INDEX (FK_TABLE_2))
Thanks for any clues.
--
Tim Ward
, foreign keys, procedures, ...).
--
Tim Ward
which keeps a
connection open permanently and repeatedly re-runs the same procedures
in different transactions? Does it need to drop and recreate the
connection in order to take account of any SET STATISTICS done by other
people, or not?
--
Tim Ward
On 14/04/2015 11:39, Tim Ward wrote:
If SET STATISTICS is done on one connection, when does it take effect?
What about a transaction that was already running at the time someone
else did SET STATISTICS, does that use the new statistics for any new
statements it runs (where all the code
a connection that was already in existence at the time
someone else did SET STATISTICS, does that use the new statistics for
any new transactions it runs (where all the code running is in stored
procedures)?
--
Tim Ward
like the ones you get from
profilers for conventional languages.
--
Tim Ward
--
Tim Ward
out by constant folding, so it's not
something I'd have thought of trying for myself!
--
Tim Ward
On 31/03/2015 20:00, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
On Mar 30, 2015, at 7:01 AM, Tim Ward t...@telensa.com
[firebird-support] firebird-support@yahoogroups.com wrote:
Sorry about this, but I really can't work out what's going on here, and
could do with some
this, so they will act as if it is string of 32
characters. Mark
So my temporary fudge to trim() the result is actually the best that can
be done, and it's a good thing I'm not expecting the presence or absence
of trailing spaces in VARCHAR fields to be significant, it looks like.
--
Tim Ward
will transliterate as
necessary, but padding an eight character string with 24 spaces to make
a 32 character string isn't any sort of transliteration I'm familiar with.
--
Tim Ward
representation, as the last stage of a potentially long and
complex sequence of operations.
I've never seen anyone go to remotely as much trouble to get this stuff
right since then. I can't, however, see such an approach having a
problem with the example above.
--
Tim Ward
On 24/03/2015 18:27, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
24.03.2015 18:42, Tim Ward wrote:
[#] Yes, well, there's then the question about how come you're allowed
to get a database into such an illegal state in the first place, isn't
there.
I'd say
in general.
[#] Yes, well, there's then the question about how come you're allowed
to get a database into such an illegal state in the first place, isn't
there.
--
Tim Ward
that all the time, there's no performance
issue in practice, setting up the connection is a fraction of the cost
of running a statement that actually does anything.
--
Tim Ward
first
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-execstat.html
Regards,
Vlad
--
Tim Ward
be *that* cheap?)
--
Tim Ward
, but there is of course no such thing as a theoretically
perfect query optimiser.)
--
Tim Ward
the whole business?
--
Tim Ward
actually used anywhere. I've now got to fix that code to be
extremely careful about *ex*cluding unneeded CTEs - it's currently aimed
at being extremely careful to *in*clude CTEs that *are* needed.)
--
Tim Ward
On 17/02/2015 09:44, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
On Tue, 17 Feb 2015 09:41:56 +, Tim Ward t...@telensa.com
[firebird-support] firebird-support@yahoogroups.com wrote:
Why?? Why does that have to be a failure?? Why can't Firebird just
ignore
does not use
the descending index on INVOICES to speed up things.
Is there a way to force the optimizer to use the descending index
instead of sorting all the resulting rows?
I am using Firebird 2.1 on Windows.
Thanks in advance.
Fulvio Senore
--
Tim Ward
.)
--
Tim Ward
of the query should not affect the
output of the optimiser), but this doesn't (always?) seem to be what's
happening.
--
Tim Ward
behave like this one.
--
Tim Ward
data to PHP scripts, it's not assuming an internet connection more than
once a day.
--
Tim Ward
responses. We're doing this by having the Android
app access a URL on our server and send or receive an XML file which are
processed into and out of the database by server side code.
--
Tim Ward
On 13/12/2014 09:14, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
On 12-12-2014 15:38, Tim Ward t...@telensa.com [firebird-support] wrote:
On 12/12/2014 14:15, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
What is the default character set of your database
.
But when I do a SELECT * FROM ... (from PHP using ibase_fetch_assoc) I
don't get the string
'A'
I get the string
'A '
(three spaces after the A). Yes this may be a PHP question, but just in
case it isn't, any ideas?
--
Tim Ward
. Connection charset appears also to be UTF8.
--
Tim Ward
exist?
--
Tim Ward
of languages all with slightly different rules for
regular expressions, it's not a surprise if any non-trivial regular
expression needs changing between languages, you just have to read the
rules for the new language.
--
Tim Ward
from viruses and malware because avast! Antivirus
http://www.avast.com/ protection is active.
--
Tim Ward
(not contained in either an
aggregate function or the GROUP BY clause)
Any advice is welcomed as this has me stumped as well as my SQL expert
mate
Thanks
Andy
--
Tim Ward
set.)
So, my questions:
(1) Have I got this right? Is the second query a correct expansion of
COALESCE that produces the same results as the first query?
(2) If so, is it indeed the case that the optimiser doesn't understand
how to expand COALESCE?
--
Tim Ward
for a pure firebird sql solution. We
are using Firebrd 2.5.
Any pointers on how to do this will be much appreciated.
Regards,
-Ed
--
Tim Ward
of the cleanup job, thus putting the
cost back with its owner. In other words you can't delay the garbage
collection, but you can make it happen earlier so that it's predictable.
--
Tim Ward
get the file not found message
when actually what it should say is access denied.
--
Tim Ward
Beckmann thomas.beckm...@assfinet.de
[firebird-support] wrote:
userClause is probably null. Then the entire string will be null.
Am 25.06.2014 16:08, schrieb Tim Ward t...@telensa.com [firebird-support]:
Anyone know what this error message actually means?
Yes I am trying to run
looking like one!! - is that elementId
is null (neither of the other variables can ever be null). Does that
make sense?
--
Tim Ward
On 23/06/2014 13:12, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
23.06.2014 14:48, Tim Ward t...@telensa.com [firebird-support] wrote:
I've got an INSERT statement like:
INSERT INTO table( list of columns )
SELECT list of columns
FROM table whose name
this
using EXECUTE STATEMENT.
But what, please, is the correct syntax for using EXECUTE STATEMENT for
an INSERT INTO ... SELECT ... RETURNING? - this isn't an example usage
which I've been able to find in any of the documentation.
Thanks.
--
Tim Ward
Thanks - the procedure does actually compile if I do that, which is a
good indication! (I can't actually try running it just yet.)
On 23/06/2014 13:12, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
23.06.2014 14:48, Tim Ward t...@telensa.com [firebird-support] wrote
On 27/05/2014 16:17, jakef...@yahoo.com [firebird-support] wrote:
In general, does it make a difference whether the filter conditions
are in the JOIN or WHERE clause?
In particular, if there are outer joins you can get different results.
--
Tim Ward
of it for me was to replace the em-rule
with a minus.
--
Tim Ward
is still asked with unchanged wording but can
see no reason why it shouldn't be! - today's essay might be about
something like how to represent Chinese in the from line of an email.
--
Tim Ward
,
Martijn Tonies
Upscene Productions
http://www.upscene.com
--
Tim Ward
SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: Tim Ward
Sent: Friday, April 25, 2014 10:27 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] non us characters in comments fail
I'm using v4.4.5.0. I can't check what others are using as they aren't in
the office
approach. I will consider it, maybe it would be sufficient
for my needs.
Yes, I'll note this idea, I've got a similar query I'll probably have to
speed up one day!
--
Tim Ward
++
Visit http
need to be calculated. (To put it very very crudely.)
--
Tim Ward
the reader doesn't
gain anything.
--
Tim Ward
and what is today
column number 2 may become column number 14 two days later.
This, in turn, leads to potential problems because you think it's
ordering by something whereas instead it's ordering by something else.
A
On Mon, Apr 7, 2014 at 2:58 PM, Tim Ward t...@telensa.com
mailto:t...@telensa.com
that Firebird read 10 records for PersonTable and 10 for
City table, but it reads 210.
The real problem is that I have millions of records in the database,
and a simple consult can take minutes when it could take few seconds
with an optimized plan.
What options do I have?
Thank you
--
Tim Ward
of doing it? (Eg rewriting the stored procedure in PHP.)
--
Tim Ward
1 - 100 of 127 matches
Mail list logo