Re: object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-08 Thread Ivo Marcelo Leonardi Zaniolo
A agree with you, Cal. Migrate to another DB engine could not solve the problem. I just mentioned that, cause there another good opportunities. But it doesn't mean that will be easy and cheap. Ivo Marcelo Leonardi Zaniolo +55 71 9302 3400 imarcel...@gmail.com www.informatizzare.com.br

Re: object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-08 Thread Cal Leeming [Simplicity Media Ltd]
Just to chime in again here, there are many alternatives, but don't give up on MySQL straight away. Solutions such as Cassandra, MongoDB, Hadoop clustering etc are also lovely, but they all come at a cost (whether that be additional risk, development time, performance/feature trade offs, the

Re: object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-08 Thread Ivo Marcelo Leonardi Zaniolo
Some years ago I got a similar problem using postgresql. To.improve the bulk performance I chose to disable all keys and indexes after bulk the data. On postgres it solved my problem, but if you need more performance, and have more than one computer, I recommend that you take a look at Cassandra,

Re: object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-07 Thread Cal Leeming [Simplicity Media Ltd]
Hi Anton, In short, attempting to do any sort of bulk import "out of the box" with the ORM, will always end with bad performance. No matter how fast your disks are (SSDs with 4000 iops in RAID 1 for example), you'll still only get around 0.1s per insert via the ORM on a single thread, and if you

Re: object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-06 Thread creecode
Hello Anton, On Friday, August 3, 2012 9:05:47 AM UTC-7, Anton wrote: > My Problem: I will populate it with 5 items. > > Has Django really such a bad performance for data insertion? > > I can't believe it, so ... can somebody give me a hint? > Is there a doc page dedicated to

Re: object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-03 Thread Kurtis Mullins
If you plan to create a batch of objects, I wouldn't recommend going that route. Instead, check this out: https://docs.djangoproject.com/en/dev/howto/initial-data/ Has Django really such a bad performance for data insertion? The Object Relational Mapper does quite a bit more than simply write

object.create speed, creating 3 objects takes 1 sec in sqlite

2012-08-03 Thread Anton
Hi I am new to Django. I worked through the tutorial. I created a small test app on: - Win7 64bit - python 2.7.3 (32bit) - Django 1.4.1 - using the development server Now I wanted to populate the (sqlite backend) database with a python script. My Problem: I Insert 3 Object (like