Khamis Abuelkomboz wrote:
Hi
How many records contain your table? Your select command scans all the
table entries and I guess that the database uses the standard index.
try the following command to tell the db which index it should use:
select distinct date from mytable where yearmonth = '2
Hi
How many records contain your table? Your select command scans all the
table entries and I guess that the database uses the standard index. try
the following command to tell the db which index it should use:
select distinct date from mytable where yearmonth = '200508' order by date
Anothe
Perhaps you could create a table with the results (e.g. columns
yearmonth, date, hasrecord=0|1) and create triggers for the main table
so that if the records change, the triggers change the value in the
result table.
Jakub
Tom Deblauwe wrote:
Hello,
I'm using SQLite 2.8.16, on an embedded s
Have you tried putting the yearmonth in 2 different columns, not sure if it
will be
any faster, but I think it will, due to being a lot of them repeated.
Check you bandwidth and see if it's enough for your web users to access this
query
remotely.
Peace
> Hello,
>
> I'm using SQLite 2.8.16, on an
Hello,
I'm using SQLite 2.8.16, on an embedded system, and I have a question.
I have a database with one table, containing all my records. Each has a
field 'yearmonth' which contains for example '200508', and also a field
'date', which indicates the day of that month. I want now to make an
over
5 matches
Mail list logo
