... This looks more like a 'shot in the foot' to me. Something like: if (inserting) update tablesrows set table_rows = table_rows + 1; if (deleting) update...
... Obviously the first query allocated 'fresh' memory, so the second one used that. And not entirely, since it released some as well. In any case, the second...
I forgot to put LIST function in sql to look like this: Select m.Mastername||(select LIST(d.DetailName,’;’) from DetailTable d where d.MasterId=m.MasterId)...
I think I got a simple solution now to get the estimated table row count and sofar it seems to be working well: SELECT DISTINCT 1 / I.RDB$STATISTICS FROM ...
Forget about this one. It worked on the table I was testing with but not on others and I think I have a good solution now as posted earlier. RBS _____ From:...
I do not understand the problem here, how long does Firebird need to do SELECT Count(*) FROM InvoiceItems; in the worst case, anyway ? I can't imagine Firebird...
Timothy Madden
terminatorul@...
Oct 1, 2008 10:24 am
97265
Can't test on FB now, but just tested on IB 5.6 on a table with some 8 million rows and it took 12 secs. RBS...
... Maybe you should try implementing this feature yourself, and then you'll see how 'simple' it is. I'm sure developers would welcome a patch for this 'easy...
Hi, We have a problem running Firebird 1.54 over the internet. We have firewalls on both sides client and server. We have made the RemoteAux Port 3051 and...
... Thanks, you're the first to actually answer my question. ;-) ... I'm using Qt's thread-safe "Queued Connection" variant of the signal/slot mechanism. This...
Daniel Albuschat
d.albuschat@...
Oct 1, 2008 11:53 am
97270
... Five hundred years. ... Yup, it does. And actually it's good that it does because it keeps developers from using this, since most of the time it is simply...
Daniel Albuschat
d.albuschat@...
Oct 1, 2008 11:59 am
97271
... To answer the original question, I use fbembed.dll with FBLib and Delphi. This SELECT Count(*) problem is really incredible. I can understand concurent ...
Timothy Madden
terminatorul@...
Oct 1, 2008 12:41 pm
97272
... if you want tables to have a count (as opposed to result sets e.g. joins) then it's quite trivial to do this yourself via triggers and a small maintenance...
Hi Daniel, Just had a read of your thread. We're using Qt and Firebird... on Windows and Mac (Linux in the future), writing in C++. Everything is working...
How do I add a field of the type Time in Firebird I tried to give a sum (field_time) but returns error saying that does not support Vinicius. [Non-text...
Hi, ... What result would this give you? How can you calculate the sum of 03:00AM and 12:34 PM? Martijn Tonies Database Workbench - tool for InterBase,...
I would like the following result. 01:00 + 03:30 + 01:45 = 06:15 would return only the sum no matter whether it is morning or evening, this field saves time ...
... Because such count would have to be kept in system tables, and it would mean versioning system tables - which has proven to be tricky so far. -- Milan...
Then what you want isn't a time field, you want a duration. By subtracting one TIME value from another, the result would be in the datatype you're looking for...
At the Firebird conference last week, Dmitrij Kouzmenko said that he didn't recommend doing CREATE TABLE without exclusive access (at least that's how I...
Hi, ... You cannot "sum" time, you can only "sum" duration. The data type TIME stored "time of day", which is different. If you have chosen to store "time...
For the record... We're also using Delphi, using IBObjects and dbExpress and soon we'll use FIBPlus. Martijn Tonies Database Workbench - tool for InterBase,...
... How about letting the system tables reflect the base version of the table and put the per-transaction row-count toghether with the version-specific data of...
Timothy Madden
terminatorul@...
Oct 1, 2008 2:23 pm
97285
... and ... of ... No offence, but this only makes sense if you do a "select count(*) from table". That is: no specific columns (cause then the result can be...
... Well, the OP seems to want his tables displayed in some grid control, which needs a scroll bar, and someone else reported an 8 milion rows table needs...
Timothy Madden
terminatorul@...
Oct 1, 2008 2:38 pm
97287
... would ... table ... data ... no ... As I said... ... This is the -single- situation where this would make sense. It won't ever ever make any sense outside...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
