Is there a way to move the journal to say use a temp directory? We're
doing some stuff with dbs on SD-cards and it's dog slow. Writing to them
is dog slow too. So is transacting to them. 3 writes on slw media.
Is there a way to have the journal in the faster local flash memory,
then when it's
Hi All,
I am planning to migrate to SQLite for my embedded system application.
Currently we have a flat text file which we read and write using normal
C++ routines. Whole of the configuration is written everytime some
change happens. We do it using ofstream. For reading any object, we keep
Brannon wrote:
It was just a warning.
Instructions for MSVC added to the README.
> Thanks for the info. Points 2, 4 and 5 are covered by the
> Makefile (DB.h is generated with javah), but I'll patch the
> project for the variable declarations and the cast. Though I
> have a feeling the cast is unncessesary, did VC throw an
> error or warning for that?
It was just a
Brannon King wrote:
To compile the binary with VC71, I had to
1. move a dozen variable declarations to the top of the function
2. download the DB.h file separately from the build tree
3. change the jstrlen to end with "return (int)(s - str) - suppChars"
4. change my sqlite3 lib build to #define
Cool!
I will try that!
Thanks Igor!
On 7/31/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado
<[EMAIL PROTECTED]> wrote:
> How can I optimize this query
>
> select * from table where col1 = 5 && col2 = 15;
>
> If I know that col2 I have 15 rows and col1 I have
Cesar David Rodas Maldonado
<[EMAIL PROTECTED]> wrote:
How can I optimize this query
select * from table where col1 = 5 && col2 = 15;
If I know that col2 I have 15 rows and col1 I have just 100
rows, I know that because I save that data in another table.
How can I do for search first
Hello to all!
How can I optimize this query
select * from table where col1 = 5 && col2 = 15;
If I know that col2 I have 15 rows and col1 I have just 100 rows, I
know that because I save that data in another table.
How can I do for search first where is minus number of result?
The two
[ANN] SQLite Manager - Browser - Editor + Deep SQL
Windows/UTF-8 only.
www.sqlight.com
Four query views.
Transactions supported.
Table Edit
- complete editing flexibility. No limitation how a table is arranged for
editing as long as Primary Key present.
- Lookup List
- Save Queries
- Save
To compile the binary with VC71, I had to
1. move a dozen variable declarations to the top of the function
2. download the DB.h file separately from the build tree
3. change the jstrlen to end with "return (int)(s - str) - suppChars"
4. change my sqlite3 lib build to #define
Mikey C uttered:
Is there any performance or other gain in writing:
select sum(column_a) + sum(column_b)
vs
select sum(column_a + column_b)
The second should be faster, as I'd expect aggregate functions to be more
expensive than expression additions. The second would have half the
Olaf Beckman Lapr� uttered:
Hi,
Is it possible to read the undamaged parts of a damaged .db file? This
way I can copy the undamaged parts to another database. Or support to
repair the .db file in such a way that it becomes readable again and the
undamaged parts can be read.
You can try
Hi,
Is it possible to read the undamaged parts of a damaged .db file? This way I
can copy the undamaged parts to another database. Or support to repair the .db
file in such a way that it becomes readable again and the undamaged parts can
be read.
Olaf
Agree. Actually, I should have instead created the same database on the
windoze port and see if the numbers are the same.
Mario
[EMAIL PROTECTED] wrote:
>
> Is it normal it takes 13,000 mallocs
>
That depends on your database schema and the data you
are storing.
--
D. Richard Hipp
Ok, i´ve found the key... :-)
ORDER BY coalesce(fi.name, 'Z') desc
Regards,
ecc
emuControlCenter - http://www.camya.com/ecc/
--
View this message in context:
http://www.nabble.com/collation---order-null-values-to-end-of-result-tf2026443.html#a5575844
Sent from the SQLite forum at
i use the php-extension for this (sqlite 2.8). The typeof-syntax isnt allowed
here :-(
--
View this message in context:
http://www.nabble.com/collation---order-null-values-to-end-of-result-tf2026443.html#a5575705
Sent from the SQLite forum at Nabble.com.
I'm throwing this here, I assume that it would not be too much work to
complete this patch. the aim is to support the sql92 syntax insert into
default values;
any comments? hints?
thanks in advance,
Mario Frasca.
cvs diff: Diffing src
Index: src/insert.c
For the Borland DbExpress driver I've fixed the support for turning on
and off the pragma setting for FullName. Download your registered
sources or binaries from the known urls.
Regards,
Marco Wobben.
http://www.bcp-software.nl
Will that work also in sqlite2?
--
View this message in context:
http://www.nabble.com/collation---order-null-values-to-end-of-result-tf2026443.html#a5575249
Sent from the SQLite forum at Nabble.com.
ecc <[EMAIL PROTECTED]> wrote:
select
*
from
files
left join meta_data on files.id=meta_data.id
order by
meta_data.title asc,
files.title asc
How can i change the collation sequence to get num -> string -> null?
order by
сase typeof(meta_data.title)
when 'integer' then 0
when
Hi,
i have the problem with a search-result order.
select
*
from
files
left join meta_data on files.id=meta_data.id
order by
meta_data.title asc,
files.title asc
Ok, ther is no meta-data for every files, so the join result for
meta_data.title asc is NULL.
So, every results with no meta-data
Martin Pfeifle wrote:
could you please shortly outline the differences between your jdbc driver
and the one developed by Christian Werner?
I haven't looked too closely at the other driver, but from what I have
seen, it is designed to work with the old callback exec() functions,
so it supports
Hi David,
could you please shortly outline the differences between your jdbc driver and
the one developed by Christian Werner?
Best Martin
- Ursprüngliche Mail
Von: David Crawshaw <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org; Martin Pfeifle <[EMAIL PROTECTED]>
Gesendet: Sonntag, den
23 matches
Mail list logo