Hi Danny! ... The problem with this solution is that (:value = -1) is evaluated for each record in the table. Hence, it is similar to solution 1 and 2 (at ...
... If I knew my Firebird and C memory allocation a little better, it would have been sorely tempting to change the code right there and then. cmp_literal() in...
... I am not sure ! I was talking from the top of my head. One problem that I remember is the 64kb limit on a SQL statement, it should be removed to insert...
I believe UNION ALL , instead of just UNION will select what you wish ... From: "Dennis McFall" <dennis@...> To: <firebird-support@yahoogroups.com> ...
hi, you can try using the MoleBox software (http://www.molebox.com/) with this tool you can link a DLL into an EXE file best regards, Joćo Carlos ... De:...
... If it is done inside PSQL (trigger or stored procedure), you can check the ROW_COUNT context variable. I am not sure if it is possible using standard DSQL...
Hi All, I want to create a stored procedure in iSQL script so then I can apply using isql command prompt & the Script. Any body got any simple example to give...
... You seem confused on a couple of points. VB does not usually interact with iSQL. iSQL is just a client application that connects to the database server...
Yes, firebird fdb files are completely plataform independant! You just have to shutdown that file before making the copy. Best, Valdir ... From: David Wishnie ...
... Wow, resurrecting some old threads here. I think you will find that the files are only platform independent if you are moving between the same endianness...
Hello Sean, 500000 or more updates of the same record without reading is a problem for Firebird. Memoryusage increases fast and performance goes down. Creating...
I have the following two selects that deliver the same resultset,at least as far as I can see, but then plan choosen for the second one executes much slower...
... Why all these parenthesis, Joja? You have specifically told it to left join ch_daten to autrags_daten_run before joining to ch_daten and leaves the...
... The gstat tool (-a switch) can tell you how many pages each table takes up as well as the size of the data page. That should be a pretty close estimation. ...
... Isn't it the optimizers tasks to switch the things around to get the best performing plan whose output conforms to what I initially requested in terms of...
... The table has 500,000 records and a total size of 2GB. Column1 and Column2 are integer fields and there is an index on Column1 alone and a compound index...
I prepared a simplified example where the optimizer does not choose the optimal plan. The requested result is the same for each query, as far as I can see,...
... * You forgot to use ORDER BY Column1, Column2 clause. * How many records are there for Column1=1 ? Instead of ... where column1 > 1 ... try this one ......
Thank you Adam for the info, My appology for not describing the question. You are absolutely right. What I ment was I need the syntax to write SP in iSQL....
Hi All, I'm not clear on the above and anyone that can give me any 'definitive answers' then much appreciated. One time the considered advice seemed to be that...
... That's it. Thanks! With information gleaned from the IB docs, ibase.h, and some code at http://www.krugle.com/examples/p-3ZxxoAKYIVuyghiJ/StatementBase.cs...
Is it better to UPDATE, detect 0 rows affected, then INSERT or INSERT, detect duplicate key, then UPDATE? The INSERT will succeed once, while the UPDATE will...
