Hi!
Can I take it for sure that the order of the rows returned by 2 queries are
the same?
The only difference between the queries is that the selected columns of the
first query are subset of the second.
Ex:
select name, age from table1 where age > 18;
select name, age, addr from table1 where
I asked a very similar question a few weeks ago and got a very precise
answer. You should search for that.
Kasper
> Lars Aronsson wrote:
>> I'm using SQLite 3.4.2, which is the standard package in
>> Ubuntu Linux 7.10. I'm running this on an otherwise idle
>> Intel Core 2 Duo CPU with 4 GB of
Hello Sam,
Just recompile the code into a new DLL and tell the environment to
create a link library. I hate DLL's myself and only use static linkage
to SQLite. Using LoadLibrary's just too much hassle.
C
Sunday, February 24, 2008, 9:37:04 PM, you wrote:
SC> On Sun, Feb 24, 2008 at 9:12 PM,
Monday, February 25, 2008, 2:13:13 PM, you wrote:
NL> On Mon, Feb 25, 2008 at 2:37 AM, Sam Carleton
NL> <[EMAIL PROTECTED]> wrote:
>> Thank you, I know all about LoadLibrary. I also saw the header file
>> that contains a structure with function pointers to all the exported
>> methods. But
On Sunday, February 24, 2008 Nuno Lucas wrote:
> On Mon, Feb 25, 2008 at 2:37 AM, Sam Carleton
> <[EMAIL PROTECTED]> wrote:
>> [...]
>> generated the stub lib I needed to link my code against and it seems
>> to run fine with the officially compiled DLL.
> The reason an import library isn't
On Mon, Feb 25, 2008 at 2:37 AM, Sam Carleton
<[EMAIL PROTECTED]> wrote:
> Thank you, I know all about LoadLibrary. I also saw the header file
> that contains a structure with function pointers to all the exported
> methods. But are you telling me that no one has published the code to
> load
On Sun, Feb 24, 2008 at 9:12 PM, Roosevelt Anderson
<[EMAIL PROTECTED]> wrote:
> To use the dll you need to use the LoadLibrary windows function and define
> pointers to each of the sqlite functions. Here is a short example to get you
> started. For more on using DLLs try this MSDN link:
>
>
>
To use the dll you need to use the LoadLibrary windows function and define
pointers to each of the sqlite functions. Here is a short example to get you
started. For more on using DLLs try this MSDN link:
On Feb 23, 2008, at 9:15 PM, Sam Carleton scarleton-at-
miltonstreet.com |sqlite| wrote:
> How do I compile a C program to use the shared DLL rather then
> statically link in SQLite?
Good question; the DLL download only has the DEF file and the DLL, but
you normally need an export LIB file to
Lars Aronsson wrote:
> I'm using SQLite 3.4.2, which is the standard package in
> Ubuntu Linux 7.10. I'm running this on an otherwise idle
> Intel Core 2 Duo CPU with 4 GB of RAM. The operation takes
> several hours and still running. Performance graphs indicate
> lots of iowait, with many
I think that you have hit a situation where the sort and index build
algorithm in Sqlite is a problem and gets limited by disk head seeking.
Others know more about this situation but I don't think there is much
you can do to improve the speed.
Lars Aronsson wrote:
> I have a database table with
I have a database table with 68 million rows and 4 columns, of
which 3 are integers and one is a short text string. I'm
now trying to create an index on one of the integer columns, that
I forgot to create before I populated the table. But it takes for
ever and doesn't seem to stop.
I
SELECT is an SQL interface to text files:
$ SELECT response_code, count\(1\) FROM access_log WHERE method = "'GET'" \
> GROUP BY response_code ORDER BY 2 DESC
response_code | count(1)
---+--
200 | 157820
404 | 25138
304 | 17938
301
Running a querry "select count(*) tbl " returned a generic error SQLITE_ERROR.
and an error message of "no such table: tbl"
It would be beneficial If the prepare returned an error code such as
SQLITE_NOTFOUND instead of a generic SQLITE_ERROR.
Thanks,
Ken
14 matches
Mail list logo