On Mon, 8 Aug 2016 10:48:58 -0700
"Kevin O'Gorman" wrote:
> Very cool. But 4? I will be running this on machines with 8 and 16
> cores. Does going beyond 4 not help much?
Four doesn't seem like a bad starting point.
I don't have any information specific to SQLite, but in general adding
cor
On 08/09/2016 12:48 AM, Kevin O'Gorman wrote:
On Sun, Aug 7, 2016 at 11:11 PM, Dan Kennedy wrote:
On 08/08/2016 02:03 AM, Dominique Pellé wrote:
Kevin O'Gorman wrote:
CREATE INDEX has two problems:
1) poor default location of temporary storage.
2) gets wedged on very large indexes.
I'm us
On Sun, Aug 7, 2016 at 11:11 PM, Dan Kennedy wrote:
> On 08/08/2016 02:03 AM, Dominique Pellé wrote:
>
>> Kevin O'Gorman wrote:
>>
>> CREATE INDEX has two problems:
>>> 1) poor default location of temporary storage.
>>> 2) gets wedged on very large indexes.
>>>
>>> I'm using the sqlite that came
On Mon, Aug 8, 2016 at 2:41 AM, Philip Newton
wrote:
> On 7 August 2016 at 22:37, Kevin O'Gorman wrote:
> > I use the LTS (long-term support) version of Ubuntu, and like not having
> to
> > keep up with all the latest. My current 14.04 is at end-of-life
>
> LTS are supported for 5 years; your 1
On 7 August 2016 at 22:37, Kevin O'Gorman wrote:
> I use the LTS (long-term support) version of Ubuntu, and like not having to
> keep up with all the latest. My current 14.04 is at end-of-life
LTS are supported for 5 years; your 14.04 is good till April 2019.
Ph.
___
Kevin asks:
" Does anybody know where the actual defaults and controlling environment
" variables are documented, by operating system? Or are they?
I believe Section 5.0. near the end of https://www.sqlite.org/tempfiles.html
describes what you're looking for.
thanks,
stephan();
___
On 08/08/2016 02:03 AM, Dominique Pellé wrote:
Kevin O'Gorman wrote:
CREATE INDEX has two problems:
1) poor default location of temporary storage.
2) gets wedged on very large indexes.
I'm using the sqlite that came with Xubuntu 14.04, I think it's version
3.8.2.
SQLite-3.8.2 is old (Dec 2013
On Sun, Aug 7, 2016 at 12:03 PM, Dominique Pellé
wrote:
> Kevin O'Gorman wrote:
>
> > CREATE INDEX has two problems:
> > 1) poor default location of temporary storage.
> > 2) gets wedged on very large indexes.
> >
> > I'm using the sqlite that came with Xubuntu 14.04, I think it's version
> > 3.8
Kevin O'Gorman wrote:
> CREATE INDEX has two problems:
> 1) poor default location of temporary storage.
> 2) gets wedged on very large indexes.
>
> I'm using the sqlite that came with Xubuntu 14.04, I think it's version
> 3.8.2.
SQLite-3.8.2 is old (Dec 2013). It's better to download and
compile
> Does anybody know where the actual defaults and controlling environment
> variables are documented, by operating system?
https://www.sqlite.org/tempfiles.html
--
Meilleures salutations, Met vriendelijke groeten, Best Regards,
Olivier Mascia (from mobile device), integral.be/om
_
RETRACTED: Not wedged, just somewhat slower than I expected. I was
expecting about an hour, and it takes 6. On reflection, it's okay. My
ideas about what's going on were wrong too -- anonymous files are used, but
only two of them at a time.
I still think it is using a poor choice of default dir
CREATE INDEX has two problems:
1) poor default location of temporary storage.
2) gets wedged on very large indexes.
I'm using the sqlite that came with Xubuntu 14.04, I think it's version
3.8.2.
I created a table, and used .import to populate it with records, about 1.4
billion of them. The resul
12 matches
Mail list logo