Posted
by alex
on Stack Overflow
See other posts from Stack Overflow
or by alex
Published on 2010-04-29T04:29:36Z
Indexed on
2010/04/29
4:37 UTC
Read the original article
Hit count: 386
A table with ~100k rows.
SELECT word FROM entries WHERE word MATCH '"chicken *"';
17 results in 46ms
SELECT word FROM entries WHERE word MATCH '"chicken f*"';
2 results in 5793ms
Why such a huge drop?
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
I followed the instructions in the documentation:
Scenario 1: Version Independent (does not use the Global Assembly Cache)
This method allows you to drop any new
version of the System.Data.SQLite.DLL
into your application's folder and use
it without any code modifications or
recompiling…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've followed the instructions given here for introducing an existing SQLite database to your Android app.
When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Im getting a database is locked (code 5) in my ListActivity the code works in the other versions of the Emulator but fails in the 4.1 version of the emulator
E/SQLiteLog( 2132): (5) database is locked
E/SQLiteDatabase( 2132): Failed to open database '/data/data/id.online.mydroid/databases/geo…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How to read data from the assets folder sqlite database file with .sqlite extension in my android application?
Thanks
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi everyone,
I have a layout which does almost what I want. There's just one bug regarding the button at the bottom. I should stay at the bottom at all times. But whenever I bring up the soft-keyboard the button will be displayed above the keyboard. This is not what I want but it should become covered…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've just created a prototype of interface for my android app and tried to run it. Unfortunately I get an error that my app has stopped unexpectedly (my reputation doesn't allow me to post images so follow my links):
screenshot of error message
This is layout mode of editing. Everything looks as…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I just updated my app and I am getting some odd complaints from people who update it. I am only getting complaints from people with non-stock android phones (phones that manufacturers have modified...HTC phones, cliq, pulse, etc), other phones like the Droid, Nexus work fine. My app (Photo Frame Deluxe)…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have problems getting some of my views aligned in a relative layout that I use inside a row of my listview.
Here is a screenshot from the layout builder in Eclipse, this is what I think it should look like:
The next image is from the emulator. Now the TestTestTest View is at the top and covers…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Whenever I use a RatingBar view in my layout, I suddenly get all kinds of compile errors. I'm using Android 2.0, but I've also tried 2.0.1, and 2.1, without joy. I also get a message: Shader 'android.graphics.BitmapShader' is not supported in Layout Editor, and an odd warning which may or maynot be…
>>> More
