Re: [sqlite] System.Data.SQLite won't work untill Iinstall+uninstallit.

On Oct 11, 1:59 am, "Joe Mistachkin" wrote: > Wamiduku wrote: > > I suppose the setup could uninstall the VC++ > runtime; however, it's typically considered "bad form" to do so (since > it's officially a "shared" component). I agree that the uninstall had better leave it

Re: [sqlite] System.Data.SQLite won't work untill Iinstall+uninstallit.

Wamiduku wrote: > > I found it! By using the trial version of VMWare Thinapp and installing > +uninstalling Data.SQLite, you can see what the uninstallation left > behind, and it is the Visual C++ 2010 Redistributable Package. > Yeah, that would do it. I suppose the setup could uninstall the

Re: [sqlite] Is it possible to optimize this query on a very large database table Oct. 10, 2011 13:53:01 GMT

Igor Tandetnik, >>> Explain the problem you are trying to solve, *not* your proposed solution. >>> <<< What we are trying to achieve is to to find the minimum row id for each unique Field Name in BLobLastNameTest where many rows can have the same FIELDNAME but distinct

Re: [sqlite] Can pre-sorted data help?

> Maybe, if we had a column called 'published_date' and we did a query > for data within a date range.. the fastest way to get the information >back would be to have an index on that column. Suppose we sorted >all the data by date - would there be a way to use that information so >that we don't

Re: [sqlite] Is it possible to optimize this query on a very large database table.

Frank Chang wrote: > Igor Tandetnik, > The fieldname groups in our BlobLastNameTable consist of > multiple rows where each pair of columns [FieldName, > BLOB[Vertices]] is unique. How so? You have FieldName declared as PRIMARY KEY. From

[sqlite] Re; Is it possible to optimize this query on a very large database table? Oct 10,2011

Simon Slavin, I tried your suggestion about creating the index: >So do this: >CREATE INDEX BLNTFieldName ON BlobLastNameTest (FieldName, rowid) But sqlite complains that rowid is not a BLobLastNameTest column. So then I tried your repeated selects. Your selects work fine but since

Re: [sqlite] new user

I have not used it, but kexi claims to offer many of the features of access: http://www.kexi-project.org/screenshots.html someone put together a really nice wiki of various admin tools for sqlite here with descriptions of features, licensing, and fees.

Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

On Oct 10, 4:01 am, "Joe Mistachkin" wrote: > Wamiduku wrote: > > So, there is something that the installation does, which the uninstall > > doesn't undo, that you have to do in order to get System.Data.SQLite > > working. The question is what, and how can you do it without

Re: [sqlite] Is it possible to optimize this query on a very large database table.

Igor Tandetnik, The fieldname groups in our BlobLastNameTable consist of multiple rows where each pair of columns [FieldName, BLOB[Vertices]] is unique. Therefore, every fieldname group does not just have a single row but instead 1000's or 1's rows. So that is why we use

Re: [sqlite] How to design this table?

> Simon Slavin writes: > On 9 Oct 2011, at 3:57am, 张一帆 wrote: >> i have some data like "a and b or c ...",there will be a word 'and' >> or 'or' which means the Logical relations between each item. > If you have "a and b or c" does that mean > (a and b) or cOR > a and (b or c)

Re: [sqlite] Multiple statements

On 10 Oct 2011, at 4:25pm, Tim Streater wrote: > Looking at the description text for sqlite3_exec (SQLite C interface), I see > this text: > > "The sqlite3_exec() interface runs zero or more UTF-8 encoded, > semicolon-separate SQL statements passed into its 2nd argument, in the > context of

Re: [sqlite] Multiple statements

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/10/11 08:25, Tim Streater wrote: > Looking at the description text for sqlite3_exec (SQLite C interface), > I see this text: That interface is generally not used. I believe it dates from the days of SQLite 2. It provides all values as

[sqlite] Multiple statements

Looking at the description text for sqlite3_exec (SQLite C interface), I see this text: "The sqlite3_exec() interface runs zero or more UTF-8 encoded, semicolon-separate SQL statements passed into its 2nd argument, in the context of the database connection passed in as its 1st argument." Now,

Re: [sqlite] SQLITE LIMIT clause

On Mon, Oct 10, 2011 at 10:27 AM, cricketfan wrote: > > SELECT * FROM test WHERE PK1 > 100 LIMIT 100 ORDER BY PK1 ASC; > > Since I have the index on PK1, I believe the rows will be returned in the > ORDER of PK1. Putting an ORDER BY clause will be a no-op. > Do you think

Re: [sqlite] SQLITE LIMIT clause

cricketfan wrote: > SELECT * FROM test WHERE PK1 > 100 LIMIT 100 ORDER BY PK1 ASC; > > Since I have the index on PK1, I believe the rows will be returned in the > ORDER of PK1. Putting an ORDER BY clause will be a no-op. Probably, but that's an implementation detail. If

Re: [sqlite] SQLITE LIMIT clause

SELECT * FROM test WHERE PK1 > 100 LIMIT 100 ORDER BY PK1 ASC; Since I have the index on PK1, I believe the rows will be returned in the ORDER of PK1. Putting an ORDER BY clause will be a no-op. Do you think otherwise? Gabríel A. Pétursson wrote: > > Be aware that if you do not specify an

Re: [sqlite] How to design this table?

张一帆 wrote: > i have some data like "a and b or c ...",there will be a word 'and' or > 'or' which means the Logical relations between each item.So how to design a > table to store the data in best way? Best way to achieve which goals? What operations do you need to perform on

Re: [sqlite] Is it possible to optimize a query on a very large database table?

Frank Chang wrote: > Florian Weimar and Igor Tadetnik, > > When I replace the GROUP BY t1.FIELDNAME with ORDER BY 1, > > select t1.FieldName,t1.rowid from BlobLastNameTest t1 where t1.r > owid = (SELECT MIN(rowid) FROM BlobLastNameTest where FieldName = >

Re: [sqlite] Is it possible to optimize this query on a very large datatabase table

Frank Chang wrote: > So, why is my query just working accidently? I take it back - the behavior of your query is well-defined, for the simple reason that FieldName is unique, so every group only has a single row in it (as someone else has kindly pointed out - I

Re: [sqlite] Can pre-sorted data help?

With the relatively new prefix option FTS4 appears to be slightly faster now...could be within the error spread though. I had to upgrade to 3.7.8 -- not sure when that prefix came in but it wasn't in 3.7.5. Might be nice if the docs mention in what version something shows up. sqlite> create

Re: [sqlite] How to design this table?

> > i have some data like "a and b or c ...",there will be a word 'and' or > > 'or' which means the Logical relations between each item. > If you have "a and b or c" does that mean > (a and b) or c OR > a and (b or c) ? > How does your software know ? > Simon. just a and b or c...,like

Re: [sqlite] Is it possible to optimize a query on a very large database table?

Florian Weimar and Igor Tadetnik, When I replace the GROUP BY t1.FIELDNAME with ORDER BY 1, select t1.FieldName,t1.rowid from BlobLastNameTest t1 where t1.r owid = (SELECT MIN(rowid) FROM BlobLastNameTest where FieldName = t1.FIELDNAME) order by 1; the explain output seems to have 40%

Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

On Oct 10, 4:01 am, "Joe Mistachkin" wrote: > > I'm not able to reproduce this locally.  As long as the "test.exe", > "test.exe.config", and "System.Data.SQLite.dll" files are in the same > directory, the tests should be able to complete. I've unpacked all of

Re: [sqlite] load database into memory java applet

On Mon, Oct 10, 2011 at 12:57 PM, wrote: > Connection conn = DriverManager.getConnection("jdbc:sqlite:memory:"); > try: jdbc:sqlite::memory: note the extra colon. i don't know if that will work, but it is at least semantically correct (whereas the version

[sqlite] load database into memory java applet

Hi all; I am new to mailing list. My database file on the net (in a http address) and i wanna load that file from an applet. I tried the below code and it gives "The filename, directory name or volume label syntax is incorrect" error. Class.forName("org.sqlite.JDBC"); Connection conn =

Re: [sqlite] Is it possible to optimize a very large database query by avoiding total index scans

Florence Weimar, Igor Tadetnik, Simon Slavin, I ran ANALYZE BLOBLASTNAMETEST in order to get better index statistics. Then I modified my query to: select t1.FieldName,t1.rowid from BlobLastNameTest t1 where t1.rowid = (SELECT MIN(rowid) FROM BlobLastNameTest where FieldName =