On 09/11/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> This is indeed a sad commentary on the state of the
> world wide web that it is now necessary to specify
> a font on every web page Oh well.
What's about CSS? It should help in this case.
--
Biomechanica Artificial
On 09/11/2007, A.J.Millan <[EMAIL PROTECTED]> wrote:
>
> > Regarding the basic "look" of the site, we were considering
> > using a style similar to the once found at ActiveState
> >
> > http://www.activestate.com/
> >
>
> However the tendency in computers screen is wider than until now. Today
You can significant increase access speed by "ANALYZE" in some cases.
--
Biomechanica Artificial Sabotage Humanoid
Hello All,
I have 3 entities:
1. town
2. person
3. alliance
Links between entities:
person owns the towns
group of persons can unites into alliance
CREATE TABLE town (
tid int, /* town id */
pid int, /* owner person id */
name char,
...
);
CREATE TABLE
Hello All,
I've tried to find documentation/help about how to read output from
EXPLAIN QUERY PLAN but without success. Can you point me where i can
get it.
And another question about timing/profiling for SQLite.
Patch from this location
On Wed, 9 May 2007 21:00:46 +0400
Tomash Brechko <[EMAIL PROTECTED]> wrote:
> On Wed, May 09, 2007 at 14:45:33 +, [EMAIL PROTECTED] wrote:
> > You need an R-Tree index to do something like this. The
> > public-domain version of SQLite only supports B-Tree indices.
> > So, no, indices are not
On Wed, 9 May 2007 11:08:26 -0400
"Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
>
> I wonder if it would be beneficial to add an additional where clause which
> can prefilter the data so you only need to perform the full calculation on a
> subset of records.
>
> I haven't done the math, but
On Wed, 09 May 2007 14:45:33 +
[EMAIL PROTECTED] wrote:
> bash <[EMAIL PROTECTED]> wrote:
> >
> > Oh... so this is implementation limitation.
> > Im currently thinking about this table:
> >
> > CREATE TABLE map (
> > x int,
> > y i
On Wed, 9 May 2007 18:13:07 +0400
Tomash Brechko <[EMAIL PROTECTED]> wrote:
> On Wed, May 09, 2007 at 17:45:52 +0400, bash wrote:
> > > One index per table rule. At first glance it seems like SQLite could
> > > use at least one index for "x=5 OR y=7"
On Wed, 9 May 2007 17:29:29 +0400
Tomash Brechko <[EMAIL PROTECTED]> wrote:
>
> On Wed, May 09, 2007 at 16:32:34 +0400, bash wrote:
> > SELECT * FROM ex1 WHERE x>'abc' AND y>'abc';
> > In this form only one indexes will be used, why not both?
>
> One in
On Wed, 9 May 2007 14:24:27 +0400
Tomash Brechko <[EMAIL PROTECTED]> wrote:
> On Wed, May 09, 2007 at 14:03:54 +0400, bash wrote:
> > Im simplify environment:
> >
> > CREATE TABLE tbl(
> > id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
> > n1 int,
On Wed, 9 May 2007 12:23:14 +0200
Peter van Dijk <[EMAIL PROTECTED]> wrote:
>
> On 9-mei-2007, at 11:28, bash wrote:
>
> > SELECT type, stamp_id, old_player_id, new_player_id
> > FROM town_log
> > WHERE old_player_id = $ID OR new_player_id = $ID
> > ORD
Im simplify environment:
CREATE TABLE tbl(
id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
n1 int,
n2 int
);
CREATE INDEX idx1 on tbl(n1);
CREATE INDEX idx2 on tbl(n2);
sqlite> select count(*) from tbl;
63026
1 query:
SELECT id, n1, n2
FROM tbl
WHERE n1 = $I OR n2 = $I
Hello All,
Im using SQLite-3.3.17.
My table is:
CREATE TABLE town_log (
id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
town_id int,
stamp_id int,
old_player_id int,
14 matches
Mail list logo
