t have to worry about it, but do take that in mind.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ite functions with user-defined ones,
so if someone wants to go the easy way (partial support for just the
common western scripts) it's easy. And already done by many, if you
search the mailing list.
As a final note, SQLite 2 never had any support for ISO-8859-X
collations, so you have no reason to believe SQLite 3 would have it.
Regards,
~Nuno Lucas
>
> Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
no "true answer" (TM) exists.
If I remember correctly, you can use the header in C89 mode
with the Linux libc, so you could workaround with that in mind.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-
But I'm not sure if it's exactly the same as if from a select.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
is not compiled for large
file access that flag will not be present.
The latter is what happens using the pre-compiled sqlite binary.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
i -O3 -DNDEBUG=1 -D_FILE_OFFSET_BITS=64 sqlite3.c shell.c
-ldl -pthread
The resulting binary (sqli) will be compiled with large file support
(I verified it was using strace).
Regards,
~Nuno Lucas
P.S.- While this could be considered an Ubuntu bug, the truth is that
the linux shell binary on th
x-gnueabi
Thread model: posix
gcc version 4.4.1 (Ubuntu 4.4.1-4ubuntu8)
It takes 26 minutes to compile the amalgamation source on this device,
so it took me 52 minutes of compile time just to confirm this, so I'm
not very inclined to do a full "make test", but if there is a real
dd, mm-dd-yyy, dd-mm-), etc, is when we
decide the order of the items to show (the order the user viewing the
data expects).
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t.o
>
> Thanks for all your help!
Glad you got help from others, as I really have no idea on how to compile
things
on Mac OS.
Regards,
~Nuno Lucas
>
> --Emyr
> ___
> sqlite-users mailing list
> sqlite-users
Roger Binns wrote:
> Nuno Lucas wrote:
>> (in fact, the code doesn't compile using the bundled
>> 3.4.2 version on my Ubuntu 8.04 machine).
>
> Are you sure it is the virtual table api that is the problem and not some
> other ones. I haven't changed my virt
Emyr Thomas wrote:
> On Sep 27, 6:35 pm, Nuno Lucas wrote:
>> Some time ago I had to do something similar and decided to write a small
>> virtual table implementation to treatCSVfiles as just another table.
>> This works for my uses which is to import Excel and OpenOffice f
or favor.
I believe you want to look at sqlite3_auto_extension() [1]
[1] http://www.sqlite.org/c3ref/auto_extension.html
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ING csvfile('test.csv');
sqlite> .s
CREATE VIRTUAL TABLE csv USING csvfile('test.csv');
sqlite> .mode col
sqlite> .h 1
sqlite> select * from csv;
col1 col2col3
-- -- --
123324234 124342 342342
232 fsdfsdfsd e
up to the user to
either use the second or roll their own collating extensions.
Note that it's easy enough to roll your own "icu" like extension (for
example, if you only use Win32, you could just use the native system
collation functions), but then you would need to mak
Jimmy Verner wrote:
> Sounds like I'm not welcome on this list. Go hassle someone else.
> Goodbye.
A bit sensitive, no?
I was actually defending you.
Regards,
~Nuno Lucas
> Jimmy Verner
> www.vernerlegal.com
___
sqlite-users ma
Jean-Denis Muys wrote:
> You're top-posting, it's evil, the thread is becoming messy. That said...
And you are including everything of the earlier mail, which is even more evil
than top-posting by itself.
Ok, I'm done with my rant-per-year mails.
Re
;
sqlite> SELECT oid, quote(cast(a AS BLOB)) FROM x;
rowid quote(cast(a AS BLOB))
-- -
1 X'6C696E65310A6C696E6532'
2 X'3031320A303132'
3 X'49742773206F6B'
So, as you can see, if you insert valu
the "What not to do" at the end, talking about "LIMIT" and
"OFFSET").
If my my psychic abilities are becoming weak, then please supply your
exact query that is getting slower (and maybe your database schema)
and then someone can give you an exact answer.
Regards,
~Nuno L
gt; but the database cannot be queried after this, and the entire program
> has to be aborted and reloaded because (I assume) of some unclosed SQL
> handles.
>
> So is there a way to terminate a query gracefully?
http://www.sqlite.org/c3ref/interrupt.html
Regards,
~Nuno Lucas
> S
handle, then all this is moot, as
all synchronization is done at the file level.
I didn't try to be exhaustive. That is your job.
Now, if you still have doubts after this I don't think I can be of any
help, as that makes it obvious my communication skills are lacking.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Jun 3, 2009 at 11:22 PM, Nikolaus Rath wrote:
> Nuno Lucas writes:
>> On Wed, Jun 3, 2009 at 2:41 AM, Nikolaus Rath wrote:
>>> Nuno Lucas writes:
>>>> On Tue, May 26, 2009 at 5:17 PM, Nikolaus Rath wrote:
>>>>> Hello,
>>>>>
On Wed, Jun 3, 2009 at 2:41 AM, Nikolaus Rath wrote:
> Nuno Lucas writes:
>> On Tue, May 26, 2009 at 5:17 PM, Nikolaus Rath wrote:
>>> Hello,
>>>
>>> How can I determine the rowid of the last insert if I am accessing the
>>> db from
AND the journal file as an atomic operation.
A work around for this situation is to start an immediate transaction
[1] (which will assure no other writes are pending, although allowing
reads to proceed), backup the database (copy the file) and only then
end the transaction (a simple "BEGIN IMMEDIAT
til they understand very well what they are doing
(it's not easy, and many time impossible, to recover a corrupt SQLite
database). If you really want speed, you can try the new async VFS,
which will do the atomic writes in a background thread.
Regards,
~Nuno Lucas
>
> thanks for the r
On Tue, May 26, 2009 at 9:47 PM, Marcus Grimm wrote:
[..]
> So the question is:
> Is it somehow normal to have only 7 transactions per second?
Yes
[..]
> Any comment on this ?
http://www.sqlite.org/faq.html#q19
Regards,
~Nuno Lucas
___
sql
h thread has it's own db handle, but don't know what will happen
you use the shared cache feature.
Regards,
~Nuno Lucas
>
> I can't believe that I really have to do a SELECT on the data that I
> just INSERTed only to get the rowid...
>
>
> Thanks,
>
> -N
le-endian (the first byte
would then be the one less significant).
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
quot;€", length("€"), length(cast("€" as blob)), hex("€");
"€" length("€") length(cast("€" as blob)) hex("€")
-- - --- --
€ 1 3
lication clock. As SQLite is not a server, most
pratical examples are for running user defined functions.
The documentation could be ommiting this, but it's an esoteric enough feature.
Regards,
~Nuno Lucas
> --
>
> --- Mitchell L Model
_
On Mon, May 18, 2009 at 7:53 PM, Pavel Ivanov wrote:
> Actually I wanted to know if it can be useful somewhere. :-)
You could have a calculator command on your application and let SQLite
parse the result for you ;-)
sqlite> SELECT 1+2*(3+4*5);
47
Regards,
~Nuno Lucas
>
> Pave
> should lock only those databases? Or they will lock each other and
> will exhibit effectively serial execution because main database in all
> connections is the same?
The lock is per database file, so they will only block (or fail with
SQLITE_BUSY) if done at the same time on the same dat
no idea how to solve it.
Maybe what is full is the partition where the temporary files are created?
Regards,
~Nuno Lucas
> Could anyone help me?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
you will be opening maybe a safe bet is to cache
connection handlers.
Regards,
~Nuno Lucas
> regards, luky
>
> ps: sqlite3_enable_shared_cache is turned on.
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
&g
s nothing to do
with SQLite itself (the SQLite "team", has nothing to do with .NET
wrappers or how distros package it).
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
early Win98 machines also lack this
conversion because it's an Internet Explorer upgrade that includes
this capability to the system (but as every machine badly needs those
IE upgrades, it should not be a problem).
If you use only the UTF-16 API then it should work (if it's the same problem).
Re
ower than the disk based one
because it's not optimized for memory use (like using B+ Trees in
memory instead of something like RB Trees, as it was on 2.8.x).
This is all from memory, so someone correct me if I'm wrong.
Regards,
~Nuno Lucas
>
> Regards -- Noah
___
);
5
sqlite> SELECT max(Data) from test_table WHERE ExternalID=2;
5
sqlite> SELECT min(Data) from test_table WHERE ExternalID=2;
-20
-
Seems to work ok for me. What values were you expecting?
Regards,
~Nuno Lucas
___
ple).
The preferred interface is using the sqlite3_prepare_v2() and related API.
sqlite3_get_table() is just a wrapper around the "modern" interface.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Jun 26, 2008 at 1:38 AM, Ryan Clark <[EMAIL PROTECTED]> wrote:
> This is a "known" issue.
> http://www.sqlite.org/cvstrac/tktview?tn=2508,6
And I had proposed a patch about a month before:
http://www.sqlite.org/cvstrac/tktview?tn=2479
Regards,
~Nuno Lucas
>
e second.
No, the SQL standard is very explicit about that.
The only way to be sure is by using an "ORDER BY" clause, but you can
use "ORDER BY rowid" if you really want to sort by the internal b-tree
index (but you need to know what
.DEF file.
Other compilers have similar systems.
I don't recall the exact parameters, so just look at the command help
(or google is your friend).
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
version of sqlite3_open - ticket 2479 [1]. I believe that is
because the OEM removed the UTF-8 character mapping from the OS build.
The ticket has a possible workaround.
Regards,
~Nuno Lucas
[1] http://www.sqlite.org/cvstrac/tktview?tn=2479
> Cheers,
> Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
un it
> under WndowsXP it takes about 2 hours!
> Does anybody know why?
Use transactions, that is, start with a "BEGIN" and finish with an "END".
You will see that all your inserts will drop to just seconds instead
of minutes (in Linux AND Windows).
Regards,
~Nuno Lucas
___
all exactly if in
4.0 itself it compiles out of the box).
Other than that, just use the last SQLite version.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
eems the right thing to do, and
version numbers are cheap.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ror(s), 0 warning(s)
>
> Where i can get this tcl.h file
If you don't need TCL support just don't include tclsqlite.c in your project.
For you information, TCL is a script language, and SQLite includes
"native" support for it.
If you don't know about it then I guess you d
n?
>
Any of your 2 options would work ok.
If you will do mostly reads, options 2 may give you better
performance, because many simultaneous readers can access the database
at the same time, while when one is writing all others must wait.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
have the best
result. The same is true with any other portable file format.
Regards,
~Nuno Lucas
>
> Best regards,
> Igor
>
>
>
>
> -Original Message-
> From: Nuno Lucas [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 23, 2007 2:01 PM
> To: sqlite-user
F-16LE ?
If you only speak Japanese and all your characters are 3 bytes or more
in UTF-8 and always 2 bytes in UTF-16 which would you tend to choose?
About the endieness, you don't need to know if you don't care. SQLite
handle
ng to the x86 platform, but different library
versions).
Regards,
~Nuno Lucas
On 11/23/07, Tara_Nair <[EMAIL PROTECTED]> wrote:
> Thanks for your response, Trevor.
>
> It is what I had initially thought too, that if I built it with an older
> set of libraries it will look for th
ntation have more than enough information for the level of
detail you want.
Regards,
~Nuno Lucas
> -Original Message-
> From: Tom Briggs [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 1:41 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Performance
ension('mydblib.dll');
> SQL error: The specified procedure could not be found.
>
Seems like you didn't enable the extension loading mechanism. It
defaults to disabled for security reasons.
Check the wiki page about the SQLITE_OMIT_LOAD_EXTENSION define:
* http://w
ysinternals.com) if you
really want to have a meaningful clue on the memory usage of your
program.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
re is the problem of non-compliant browsers, but that is
another history...
Best regards,
~Nuno Lucas
On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
> Folks,
>
> I come to ask you a question that may be basic for many of you but is
> leaving me completely bewildered. My work en
changes just to compile using
only .
Used the current source code of the extensions on the contrib page.
This is not enough to create a sqlite module, but at least it compiles
without using the private sqlite headers.
Regards,
~Nuno Lucas
>
> Liam
diff -urN orig/func_ext.c fixed/func_e
c, in your module?
Don't know current compiler standard compliance, but maybe including
the "new" header file and using uint8_t, uint16_t, etc.
could be better yet (instead of every library having it's own typedef
section for basic types).
Regards,
~Nuno Lucas
record an order of magnitude slower on SQLite
(because it waits for the data to get to the disk controller) than for
Access (which just gives the data to the OS, not caring if it goes to
disk or not).
In a nutshell, ben
On 9/5/07, Cory Nelson <[EMAIL PROTECTED]> wrote:
> On 9/5/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> > What about defining __STD_IEC_559 before the compilation?
> > Acording to this:
> >
> >http://david.tribble.com/text/cdiffs.htm#C99-iec60559
> >
o maybe
libc does it by default, but the official sqlite compiled version
(which IIRC is linked with the old Microsoft C runtime DLL) doesn't.
Regards,
~Nuno Lucas
>
> Rgds,
> Simon
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
So it seems SQLite is already doing the right job.
Maybe some OS specific error? Wasn't there some discussion earlier
about the Microsoft compiler not using the full double precision by
default?
Regards,
~Nuno Lucas
> e
>
> --
> Doug Currie
> Londonderry, NH, USA
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
how round() is implemented.
Regards,
~Nuno Lucas
[1] http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c&v=1.174
>
> thanks, Serena.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
urce one (I'm sure there are good ones that deserve the
money one pays for them, but it's stupid to pay before you know the
limitations of the free alternatives).
The reason I don't explain why your way doesn't work is bec
you can also avoid reading full rows if you don't need to
(like having an index - or an autogenerated temporary index - you can
use) when sqlite does the initial "skip" part.
Regards,
~Nuno Lucas
>
> Thanks,
> Mina.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
nt inside a
transaction, don't you think?
> Why does the engine think I'm still in a transaction?
You didn't end the transaction with either "COMMIT"/"END" or "ROLLBACK".
Regards,
~Nuno Lucas
> thanks,
>
> Scott
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
body help with a workaround that doesn't need an explict (and
> rather long) list of fields in the 3-table join that is my real
> non-simple requirement?
http://www.sqlite.org/lang_insert.html
Regards,
~Nuno Lucas
> Thanks in advance,
>
> John
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
resources by having the bridge built in a
special way, like in an U shape to increase strength against the
current.
Regards,
~Nuno Lucas
>
> RBS
>
>
> > Absolutely. Big bridge or small bridge, if it fails you fall in the
> > water.
> >
> > It looks as if the br
I don't implement the code is because I believe it's
trivial enough, and if I did then it would have to wait until the
legal bureaucracy of copyright assignment was done before being merged
into the tree.
Best regards,
~Nuno Lucas
[1] http://www.sqlite.or
it is.
You also seem to be reading data from mails. Those are other standards
which you need to read, but Outlook is famous for not following those
standards, so it means a lot of hacks to to have it right.
This are just notes for you. I'm not even an expert on this.
Regards,
~Nuno Lucas
uot; to
translate the dump to UTF-8 before inserting the data into a 3.x
database. That can be more difficult than you think in case of
mismatched use of library versions.
Regards,
~Nuno Lucas
>
> Any help is appreciated! Thanks!
>
> --
> - Mitchell Vincent
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On 6/12/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> It really looks like this UTF-8 codepage is not avaiable. Is there
> any WinCE developer that uses SQLite newer than version 3.3.9 on this
> list? -> Did you have
he create statement.
Example:
CREATE TABLE x ( a, b DEFAULT CURRENT_TIMESTAMP );
INSERT INTO TABLE x (a) VALUES (12345);
b has an automatic timestamp.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
leave the decision of the name convention for the last part of the job.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On 6/28/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
On 6/28/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> One thing I noticed is that "collations" != "case change". This will
> not make it possible to use UPPER/LOWER with the same data on the
> table, b
r build their own (maybe
just rename locales).
It seems more natural to use the standard C locale names to me (the
usual "pt_PT" and "pt_BR" for Portuguese/Portugal culture and
Portuguese/Brazil culture) , but I'm open to suggestions when that
problem arise, and I'm sur
UPPER/LOWER with the same data on the
table, but maybe we can work on something in that respect, also.
Regards,
~Nuno Lucas
[1] http://developer.mimer.com/collations/charts/index.tml
[2] http://www.unicode.org/reports/tr10/
[3] http://en.wikipedia.org/wiki/European_Ordering_Rules
Jiri
ndows one, off course) exactly for the same
reason.
For small databases, the task of re-indexing is not big, but you are
forgetting you can have a database in a shared network folder, used by
PC's in different parts of the world and even different OSs (with
samba/cifs). That's why I like Trevor&#x
e usually deployed
on a single locale, and can have only the locale data they need.
Best regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
to use sqlite on WinCE 3.0, you may want to look at the
old sqlite-wince.sf.net code, which include compatibility headers for
assert.h and time.h (and support for WinCE 2.x using the legacy 2.8.x
branch).
Regards,
~Nuno Lucas
--
ut
maybe the code should have a fallback to the earlier behaviour if
CP_UTF8 is not supported on the device (as it happens with most WinCE
4.x and older devices).
Did you open a ticket for this?
Regards,
~Nuno Lucas
-
To
er() method
(maybe in conjunction with the experimental sqlite3_overload_function
method to assure an empty function exists).
Regards,
~Nuno Lucas
Thanks.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
oes anyone know other places apart from unions where deep recursion may be
used?
I believe your question is more for other places where you can avoid
the deep recursion (as the deep recursion will always lead to the same
problem).
Best regards,
~Nuno Lucas
--
o, in my opinion, your case doesn't "deserve" to be fixed.
You can make the generator create a temporary table, insert the data
on it, make the select and then drop the table, even if that would
involve more coding (at least to handle the final table dro
ck instead of the heap, but got corrected right away
in the next version).
I'm sure a lot of sqlite users in the embedded field would be
"ranting" about sqlite stack usage if that was true.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
space left. It's up to your
application to handle the error gracefully.
I'm asking this because I have a process dying (being killed) because
it exauted main memory.
That is probably a memory leak in you application (maybe some bug in
the error path).
Regards.
~Nuno Lucas
Cheers
Al
On 6/3/07, Mark Gilbert <[EMAIL PROTECTED]> wrote:
Anyone have *any* idea what is happening ?
I don't know nothing about MacOS, but you may want to check the result
of sqlite3_close. It's possible it's not closing the database [1].
Regards,
~Nuno Lucas
[1] http://www.sql
(causing a lot of problems
when porting x86 code to other platforms).
The subject is a bit more complex than this, because to really talk
about it we would also need to talk about what the C standard says
about the volatile keyword and how different compilers treat it. But
it's becoming off-topic.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
tell me where I can enable UTF-8
support. (hope this is not to offtopic).
Sorry but never used the WinCE builder tool.
Maybe someone here knows better.
Regards,
~Nuno Lucas
Regards,
Daniel
-
To unsubscribe, send
ion:
Is this a bug or is something wrong with my WinCE-Image?
It probably means your WinCE OS image doesn't have UTF-8 support
built-in, so you either have to make your own character set
conversions or rebuild the OS image with that support (if you can
change the image, that is).
Rega
;> atomic "set bit"), and also compilers typically don't optimize well with
that (so before
>> applying this patch, I would test on other platforms than gcc linux x86).
is not true.
It's true no
econds or so (is usually configurable
by a kernel parameter), but has the drawback of messing with the ACID
nature of SQLite.
Regards,
~Nuno Lucas
Somehow I don't have a problem in a tmpfs.
The strace showed no diff between tmpfs and this directory where it is
giving I/O error.
Thanks
On 5/22/0
linux, cygwin or MSYS).
After that is done, you should have all preprocessed files generated,
so you can just copy them to where you want.
Regards,
~Nuno Lucas
[1] http://www.sqlite.org/sqlite-3.3.17.tar.gz
wang
-
To u
It's up to you to feed with a collation that does natural sort.
A few thousand rows are not much in modern computer terms, but I have
no idea on the impact in terms of performance the .NET wrapper has.
Test it and you'll know.
Regards,
~Nuno Lucas
an
safely replace it with dummy functions that always succeed.
another question:
There is also a little difficult to realize the
sqlite3WinThreadSpecificData function to get the thread information,
Is this also must realize ?
If you use threads, then that would depend on your use of sqlit
On 5/4/07, Ken <[EMAIL PROTECTED]> wrote:
100% concur with Dennis.
Thanks again for a great product!
+1
I couldn't said it better, maybe even in my native language ;-)
Best regards,
~Nuno Lucas
Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote:
>
&
GB files on FAT32
(some disk utilities could even trash your drive).
I don't know if the recent vfat drivers were fixed to handle more than
2 GB files, though. Maybe no one considered it important until
recently (only now you have FAT32 USB disks with more than 4GB space
free).
Best rega
m/kb/281281
And you seem to not have noticed this link:
http://www.microsoft.com/technet/prodtechnol/windows2000serv/maintain/optimize/wperfch7.mspx
Regards,
~Nuno Lucas
3. Settings which cause Media Center to be more aggressive about
flushing its cache than Pro or Home. If this hypothesis is correct, Pro
eems you are half right in relation to Windows 2000 (I supose
that threshold value can be configured by some registry value).
But read the full article, because I would guess much of the info
there also apply to Windows XP and Vista.
Regards,
~Nuno Lucas
[1]
http://www.microsoft.com/technet/p
lob_id=:ID: ORDER BY blob_seq;
Disclaimer: I haven't tested the SQL, but you should get the idea.
Regards,
~Nuno Lucas
Thanks,
-Stan
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
re not using the lowest levels routines, nor
counting the right high level ones.
Also, SQLite has it's own memory leak detector, which you can enable
to make sure there are no memory leaks (but off course slowing down
your program a lot)
Look at the file util.c. It should give you an idea.
dern CPUs (like dynamic frequency scaling) and could give different
results on different CPUs (the motherboard can include a high-res time
source, but many don't, and some are just too slow to fetch a value).
Regards,
~Nuno Lucas
Regards
Nick
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
1 - 100 of 247 matches
Mail list logo
