John, On Tue, Nov 22, 2016 at 11:00 AM, John R. Sowden <jsow...@americansentry.net> wrote: > That was a throw back to years ago. I was trying to protect against y2k by > making each dbf for 1 calendar year. Also, these files are about 800k in > size, so I was worried about storage and search time. Storage is not an > issue anymore. I will know about search time after learning about sql > databases. Sometimes over the last 45 years I have changed the dbf > structure. This way I only change starting at the year in question, then > change the program to work with the structure modification.
Speed is simple: Just create a table and then create an index as appropriate. Shows us what query you want to run and we will help with the index creation. Then you will need to run ANALYZE against the query and EXPLAIN QUERY PLAN. Simple. ;-) Thank you. > > John > > > > > On 11/22/2016 12:33 AM, Christoph P.U. Kukulies wrote: >> >> Just a thought about your TABLE named "log16": >> >> I'm not at all a database expert but from the idea what a table is, I >> would take a more general approach. CREATE a TABLE log with >> columns year, logtext, timestamp a la: >> >> CREATE TABLE LOG (logtext TEXT, timestamp TEXT, year INTEGER PRIMARY KEY) >> >> Just my 2cts. >> >> Christoph >> >> >> Am 21.11.2016 um 19:08 schrieb John R. Sowden: >>> >>> Thank you all for your answers and direction for further information. >>> Hopefully, I will not bring these subjects up again. :) >>> >>> John >>> >>> >>> On 11/21/2016 09:29 AM, John R. Sowden wrote: >>>> >>>> First of all, I come from the dBASE/Foxpro world. There is no >>>> distinction between a table and a database. I understand that with Sqlite a >>>> database includes tables and other items. The scenario that I do not >>>> understand, is: say I have a log file with about 7 fields totaling about 80 >>>> characters per record. How do I name the database and table. Currently I >>>> say log16 for the year 2016. >>>> >>>> Secondly, I have 2 "front ends" for Sqlite on my Ubuntu 16.04 computer. >>>> Neither one allows me to set the length of the text fields in the table >>>> creation process. How does the Sqlite know how long each record should be, >>>> same with integers. >>>> >>>> No help found in the documentation on the Sqlite web site. >>>> >>>> John >>>> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
