When I launch my app the SQLite database and reads a portion of the contents
(about 30MB of a 100MB database).
On first launch it can take 50secs to load, yet subsequent loads are as fast as
10sec. What is happening under the hood?
___
sqlite-
I watched the google? video presentation DRH gave (very nice, thank you). I was
interested to hear him suggest using SQLite Tables as persistent storage for
Objects/UDTs. I want to do this for an application that has a very well defined
UDT that is used throughout the application. It would make
Is it possible to search a sequence of bytes within a BLOB?
Lets say i have a BLOB that contains 4 text fields 32 characters long ie
firstname, lastname, street, city.
Can I form a query that looks something like:
SELECT Bytes33to64 FROM MyTable WHERE Bytes33to64 LIKE 'Jones'
instead of
SELECT l
In testing a my code I came across this example.
Could someone help me understand what this syntax is doing please
(from the Seinfeld demo database examples)
..m col
..h on
..w 20 17 6 23 6
..e on
Is this some form of typecasting?
This is how they are used
SELECT f.name as food, e1.name, e1.sea
(2nd attempt... bounced back for some reason...)
In testing a my code I came across this example.
Could someone help me understand what this syntax is doing please
(from the Seinfeld demo database examples)
...m col
...h on
...w 20 17 6 23 6
...e on
Is this some form of typecasting?
This is how
In SQLite a NUL is nothing. Inserting a NUL into a column defined as Integer
for example creates a zero length entry not an Integer of value zero.
How do traditional databases with static typing deal with this?
Do they check the column delaration and convert the NUL to a zero value upon
entry?
In trying to break my code with the seinfeld database examples, I found this.
SELECT f.name as food, e1.name, e1.season, e2.name, e2.season FROM episodes e1,
foods_episodes fe1, foods f, episodes e2, foods_episodes fe2
Why does this put SQLite into an endless loop?
(I am not using the shell tool,
Just wanted to check that there is no "reset" statement that I can use with
UPDATE's.
My understanding is that for multiple Row updates the complete sequence needs
to be executed for each row ie:
"UPDATE mytable SET ' name=?, street=?, Phone=? WHERE ROWID=333"
Prepare
Bind the data
step
final
We are in Beta with a windows tool:
The RemSQL Library consists of standard dynamic link libraries (DLLs) that can
be used in a wide variety of programming languages. Because most programming
languages
support calling functions exported from a DLL, the Library Edition provides the
broadest
com
I am still not clear if page level encryption permits equality searches and
range searches?
Intuitively it would seem that these searches would require every page to be
decrypted to access the column data for each record...
unless a proxy Index is used as suggested here
http://blogs.msdn.com/lcr
Well that implies that the "parsing" decrypts each page in the database for
each query. How else would it traverse a key that is encypted?
Isn't that going to be very slow?
Cory Nelson <[EMAIL PROTECTED]> wrote: On Sun, Aug 24, 2008 at 12:07 AM, Derek
Developer
wrote:
&
appreciate a detailed explanation.
Cory Nelson <[EMAIL PROTECTED]> wrote: On Sun, Aug 24, 2008 at 12:36 AM, Derek
Developer
wrote:
> Well that implies that the "parsing" decrypts each page in the database for
> each query. How else would it traverse a key that is encypted?
>
/archive/2005/12/22/506931.aspx
If I am storing CC# or SS#, the index would contain them yes?
Igor Tandetnik <[EMAIL PROTECTED]> wrote: Derek Developer
wrote:
> Thank you for your replys, but I am still not sure I understand how a
> Query is executed on (page) encrypted data w
in a secondary
column.
Before I implement this, I wanted to make sure I understand the implementation
at the page level. Obviously a single Row can take up more than one page, but I
am still not clear if a single page can ever contain more than one Row?
Igor Tandetnik <[EMAIL PROTECTED]>
>No, the index is stored in a separate Btree. The master table simply
>stores the page number of that btree's root page. With that information
>SQLite can read and decrypt the index's root page and begin a O(log N)
>search for the first matching record, reading in and decrypting more
>pages as r
, 2008 at 6:33 PM, Derek
Developer
wrote:
> Dennis thank you for taking the time to explain that. I have read the
> Architecture page and I think I have a better idea.
>
> Since this does seem to be a viable way to protect the data I would like to
> implement the schema, but usi
I am using
sqlite3_prepare_v2()
to process my SQl queries. This takes around 80% of the processing time
compared to recovering the result set.
Once the querire has been processed i can obviously provide a progress bar when
stepping through the result set, but what progress indication is availab
I am using
sqlite3_prepare_v2()
to process my SQl queries. This takes around 80% of the processing time
compared to recovering the result set.
Once the querire has been processed i can obviously provide a progress bar when
stepping through the result set, but what progress indication is availab
Yes this is the first SELECT Querie that returns a result set.
- The Client app launches and opens a connection,
- A TRANSACTION is begun
- Multiple UPSERTS are performed if data is available ( about 5k rows of:
REPLACE INTO MyTable ( RowID, UpDtUNIX, Zip, cCode, RecID, jDate, Blob1, Blob2,
Bl
Thnk you for your thoughts. I have learned a few things as always.
There is a tenency these days to question the question these days
as most developers could benefit from a better design. It tends
to divert the question in directions that were not intended
and requires defending the underlying st
I have read and searched but I am not able to get the following statement to
run:
SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON
n.MyID=d.MyID WHERE d.Zip > 8 ORDER BY d.Zip
I just get error at "."
I tried specifiying the databse name without the file extensio
Thank you for all your help.
The ATTACH works ok but still not able to execute the query
LEFT OUTER JOIN db2.TableTwo n ON n.MyID=d.MyID
Error = UNKNOWN TABLE db2.TableTwo
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqli
Hello,
There is no need to get upset. I am trying to simplify the table names and
column names to make your life easier...
You can assume that I have carefully studied the responses I got and tried
everything suggested. I have also read all the links given. Thank you for those
I then implemente
To make it really easy, I have created three .sql files and an application that
is NOT command line akward. There are three .sql files with the statements
needed to create two databases and execute the outer join.
Drag and drop them onto the application to execute them...
http://www.transferbigfi
yes the example works as expected. This is the first step in debugging this
problem which could of course turn out to be my code. But since you were baying
for something to execute... I should also say that it is interesting to note
the "vigor" with which some of you are 'helping'!
The next ste
>And every reply, even if it is not helpful, is worthy of grateful
>thanks because it is being provided free by a list member.
This is why i put help in quotes.
Please tell me how helpfull comments like:
"Rule 1: Assume nothing. Demand proof.
"
"So produce believable evidence.
"
"Nobody is going
26 matches
Mail list logo