I have a network of computers that share a SQLite file.
Two tables share sales information: current and historical.
When I record a new record I must put a code equal to the major + 1.
I need to put the database in exclusivity to avoid recording records with
the same code.
How I do this ?
Hi,
I have a phone book (bm_ppal), 726.000 rows, 10 columns
This phone book have this columns
Name Declared Type Type Size
nbmId INTEGER INTEGER
nbmCodigo VARCHAR (6) VARCHAR 6
abmNombre VARCHAR (320) VARCHAR 320
abmNombrePlano VARCHAR (320) VARCHAR 320
nbmCiudad INTEGER INTEGER
nbmTelefono
What are the orders to get the following text ?
I tried with:
.once prueba.txt
.output prueba.txt
.log prueba.txt
.timer ON
.echo ON
PRAGMA integrity_check;
...
but I did not get the lines "Run Time..." into de file
SQLite version 3.14.0 2016-07-26 15:17:14
Enter ".help" for usage hints.
Hi,
thanks: Donald Griggs, John Gillespie, Simon Slavin
I have a phone book (bm_ppal), 726.000 rows, 10 columns
This phone book have this columns
Name Declared Type Type Size
nbmId INTEGER INTEGER
nbmCodigo VARCHAR (6) VARCHAR 6
abmNombre VARCHAR (320) VARCHAR 320
abmNombrePlano VARCHAR (320)
> Which is the fastest way to count the records of a table. ? And records
> that meet a condition?
I have a table with 726.000 registers.
SELECT COUNT(*) FROM MyTable << is very slowly
SELECT COUNT (RowId) FROM MyTable ORDER BY PrimaryIndex << is very FAST
SELECT COUNT(RowId) FROM MyTable
Hi,
Which is the fastest way to count the records of a table. ? And records
that meet a condition?
regards
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
6 matches
Mail list logo