Re: [sqlite] Slow performance with Sum function

Trainor, Chris wrote: > After running vacuum, sum is fast on the original table. However, > running vacuum took a long time, so I'm not sure if that is a feasible > solution. Is there any way to prevent fragmentation in the first place? > If not for the whole database, then for a specific table?

Re: [sqlite] How do I do this join on multiple columns?

yaconsult wrote: > SQL newbie here. I have data in a couple of tables that I need to relate. > But I don't know how to relate on more than one column. I'll not go into > detail about why the data is formed the way it is - it comes from other > programs. > > For example, let's say there are a cou

Re: [sqlite] How do I do this join on multiple columns?

Rich Shepard wrote: > On Mon, 2 Mar 2009, yaconsult wrote: > > >> SQL newbie here. >> >If you'll be doing a lot of coding in SQL, take a look at Joe Celko's > other books. He's been writing on database issues for more than a quarter > century, and I remember reading his columns in DBMS

[sqlite] Is snapshot backup supported for SQLite2?

Hello Folks, I am dropping by to get a definitive answer to a question recently raised. Can anyone here tell me definitively if backing up SQLite2 by taking a snapshot of a live database is supported? The particular operating system is Solaris 10 but I am curious about any platform where sna