Hi all,
I would like to know if there is any difference
between using 3 indexes on three different fields or
just an index which groups them, in terms of physical
size and performance.
I have seen that sqlite cannot use more than one index
at a time, so I was wondering if the second option is
alwa
Hi Igor,
Can I know the Maximum size of Record in sqlite or Can I
know the maximum size of NUMBER,TEXT and BLOB Data types.
Regards,
G.Satish.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
On 12/10/08, L B <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I would like to know if there is any difference
> between using 3 indexes on three different fields or
> just an index which groups them, in terms of physical
> size and performance.
> I have seen that sqlite cannot use more than one in
"L B" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I would like to know if there is any difference
> between using 3 indexes on three different fields or
> just an index which groups them, in terms of physical
> size and performance.
Yes. In both cases, there are queries that will
Yes, i think so.
Satish schrieb:
> Hi,
> I have seen the link which you sent.I didn't found any thing in
> which you sent regarding the size of number or text
> Field.In the link which u sent there mentioned the size limit of blob I
> didn't found any size limit regarding text and number.Can
On 12/10/08, Satish <[EMAIL PROTECTED]> wrote:
> Hi,
> I have seen the link which you sent.I didn't found any thing in
> which you sent regarding the size of number or text
> Field.In the link which u sent there mentioned the size limit of blob I
> didn't found any size limit regarding t
Hi,
I have seen the link which you sent.I didn't found any thing in
which you sent regarding the size of number or text
Field.In the link which u sent there mentioned the size limit of blob I
didn't found any size limit regarding text and number.Can I assume the size
of number and text as u
Hi,
See http://www.sqlite.org/limits.html
Martin
Satish schrieb:
> Hi Igor,
>
> Can I know the Maximum size of Record in sqlite or Can I
> know the maximum size of NUMBER,TEXT and BLOB Data types.
>
>
>
> Regards,
>
> G.Satish.
>
> ___
"Satish" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
>Can I know the Maximum size of Record in sqlite or Can
> I know the maximum size of NUMBER,TEXT and BLOB Data types.
You got your answer about text and blob. As to numbers, you can store
either 64-bit signed int
Possibly my previous post was too short. Any way I have a satisfactory solution
now. My question araised when trying to change the apswtrace tool available to
Python users. This gathers execution times via a sqlite3_profile callback
function. When I call sqlite3_changes from this profiler functi
Hello,
In a SELECT statement with multiple tables, is it possible to replace
WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses
(with the same criteria) for the same purpose (no cross join) ?
Are the two methods roughly equivalent in performance ?
We ask this because we won
On Dec 10, 2008, at 7:48 AM, Igor Tandetnik wrote:
>
>> I have seen that sqlite cannot use more than one index
>> at a time, so I was wondering if the second option is
>> always the best solution.
>
> Not always. If you have a single index on (X, Y, Z), it can't be used
> for queries like
>
> sele
Thank you very much for your reply, Igor.
The explanation you made is only valid for sqlite or
for SQL in general?
Moreover, the query:
select * from mytable where X=?;
would still benefit the index on (X, Y, Z)?
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "L B" <[EMAIL PROTECTED]> wrote
If you want help with your SQL. You should post it along with your question.
There are a lot of really good SQL experts on here that will be able to help
you.
--- On Tue, 12/9/08, jm cuaz <[EMAIL PROTECTED]> wrote:
> From: jm cuaz <[EMAIL PROTECTED]>
> Subject: [sqlite] SQL question with SQL
L B <[EMAIL PROTECTED]> wrote:
> The explanation you made is only valid for sqlite or
> for SQL in general?
For SQL in general.
> Moreover, the query:
>
> select * from mytable where X=?;
>
> would still benefit the index on (X, Y, Z)?
Yes.
Igor Tandetnik
On Tue, Dec 09, 2008 at 04:58:38PM +0100, jm cuaz scratched on the wall:
> In a SELECT statement with multiple tables, is it possible to replace
> WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses
> (with the same criteria) for the same purpose (no cross join) ?
No. That
Hi list,
I'd like ideas / recommendations on implementing and auditing to track delta
changes to tables.
I have about 6 tables in my db with different fields/columns and PK's.
My original thought was to have a single audit table for all of them such as
audit_delta ( id integer, tab text, operat
> I'd like ideas / recommendations on implementing and auditing to track delta
> changes to tables.
Here's one possibility for auditing.
http://www.sqlite.org/cvstrac/wiki?p=UndoRedo
Another possibility is to have audit tables are identical copies of
the tables being tracked, except for some tr
> I'd like ideas / recommendations on implementing and auditing to track delta
> changes to tables.
Here's one possibility for auditing:
http://www.sqlite.org/cvstrac/wiki?p=UndoRedo
Another possibility is to have audit tables are identical copies of
the tables being tracked, except for some tra
Hello!
Imho it's better to create audit table for single table. For example, we can
attach audit
database "audit" and create all tables from main db (without constraints,
triggers and checks).
Before drop or edit record ID in table T execute "insert into audit.T select *
from T where
rowid=I
Hi
Just wondering that if you set primary key in table, the column is
indexed by default in sqlite ?
thanks a lot
Richard K
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Richard Kim <[EMAIL PROTECTED]>
wrote:
> Just wondering that if you set primary key in table, the column is
> indexed by default in sqlite ?
Yes. PRIMARY KEY and UNIQUE constraints are enforced by automatically
generating a unique index.
Igor Tandetnik
Dear Cariotoglou Mike,
Are you in vaccation? I am attaching the previous emails that I have send.
If you are trying or planning to work on the same please inform, so that I
can hope that some thing is going to happen
-- Forwarded message --
From: Rajesh Nair <[EMAIL PROTECTED]>
Can I define a combination-key in sqlite. If yes, how?
Sqlite is allowing me to declare more than one PRIMARY KEY.
--
Regards
Rajesh Nair
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
24 matches
Mail list logo
