Re: Fastest way to import datas into a database

On Fri, Dec 26, 2008 at 2:34 AM, Russell Keith-Magee wrote: > > On Thu, Dec 25, 2008 at 9:02 AM, bsergean wrote: > > > > Hi all, > > > > I'm populating my database manually using a script that create ORM > > objects and save them... I have a lot of datas and it's fairly slow. > > I'm wondering w

Re: Faster Database?

Disclaimer: No knowledge beyond tweaking ... This is the variable that you want to modify to improve performances if you're using PostGres. You'll have to be root on Linux because you'll have to modify some Linux runtime params too (shared memory). shared_buffers = (BIG number) 8 - Benjamin

Re: hosting a django application

You can also look at mod_wsgi or spawning (the last one does not require any configuration nor apache). On Tue, Aug 4, 2009 at 9:53 PM, Kenneth Gonsalves wrote: > > On Wednesday 05 Aug 2009 10:00:37 am rekha wrote: >> How can i host a django application (virtual hosting in apache) using >> apache

Re: Bulk data insert

(the answer was already sent, raw SQL, anyway) (with postgresql) I would try to load just a small bit of datas with the slow create django object / save it process, then do a pg sql dump, and look at the sql that pg dump generated. Then code a python script that generate that. And then do a pg l

Re: Bulk data insert

(small update, if you try what I just suggested and use postgres (lots of if) you want to generate SQL and load with psql and not pg_restore) - Benjamin On Thu, Aug 20, 2009 at 7:40 PM, Benjamin Sergeant wrote: > (the answer was already sent, raw SQL, anyway) > > (with postgresql) I

Re: Bulk data insert

Blank wrote: > On Thu, Aug 20, 2009 at 10:40 PM, Benjamin Sergeant > wrote: >> >> (the answer was already sent, raw SQL, anyway) >> >> (with postgresql) I would try to load just a small bit of datas with >> the slow create django object / save it process, then do a pg