Hello, I know security3.fdb is not in place because I'm using the Debug dir:
F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql -user sysdba
-pass masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'user.fdb';
SQL> create user secondary pass 'sec';
Stateme
On 2-1-2014 19:37, Jim Starkey wrote:
> I presume everyone knows about standard SQL "select ... OFFSET ROWS
> ... FETCH ROWS", et al?
That is not the same as an optimizer hint. An optimizer hint for FIRST
(or FIRST n ROWS) indicates that you don't need all rows at once,
because you retrieve a
On 2-1-2014 20:50, Dmitry Yemanov wrote:
> 02.01.2014 21:43, Mark Rotteveel wrote:
> >
>> It would be interesting to know which is better for performance, given
>> isc_dsql_fetch, a FIRST (x) ROWS might perform better when small fetch
>> sizes are used.
>
> What do you mean by "small fetch sizes"
I use the WIN1258 charset but firebird can not store Vietnamese character. It
displays the "?" character.
-
Key: CORE-4312
URL: http://tracker.firebirdsql.org/
On Fri, Jan 3, 2014 at 5:26 AM, Mark Rotteveel wrote:
>
>
> ...case where isc_dsql_fetch is
> used with a small fetch size in comparison toe the entire result set.
>
> I assume the current optimization is:
> Client: execute query
> Server materializes all rows
> Client: fetch size=1
> (wait until
