Re: [sqlite] count registers ina a table

2016-12-30 Thread MONSTRUO Hugo González
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)

[sqlite] SQlite shell tool

2017-01-03 Thread MONSTRUO Hugo González
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.

[sqlite] count registers in a table

2016-12-25 Thread MONSTRUO Hugo González
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

Re: [sqlite] count registers in a table

2016-12-26 Thread MONSTRUO Hugo González
> 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

[sqlite] change ORDER BY slowly

2017-03-27 Thread MONSTRUO Hugo González
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

[sqlite] lock base

2017-09-29 Thread MONSTRUO Hugo González
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 ?