Re: Faster Database?

2009-02-27 Thread Benjamin Sergeant
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: Faster Database?

2009-02-27 Thread Matej
I agree with Clifford. I was able to speed up my postgresql database by 200% just by changing configurations how much memory database can use. On Feb 27, 9:11 am, CLIFFORD ILKAY wrote: > Sean wrote: > > Anyone have any suggestion how can I make this process faster,

Re: Faster Database?

2009-02-27 Thread CLIFFORD ILKAY
Sean wrote: > Anyone have any suggestion how can I make this process faster, or > there is any other superfast database engine than MySql? We've found bulk loading data into PostgreSQL significantly faster. Come to think of it, we've found just about everything about PostgreSQL to be faster than

Re: Faster Database?

2009-02-25 Thread Paul Nema
One option is to create a new table that is a mirror of the target table except the new table should NOT have any of the keys enabled. Using a bulk load tool add the data to the new table. Then add the keys to the new table. Drop the old table and rename the new table to the original target

Re: Faster Database?

2009-02-25 Thread Tim Chase
> I am using django+MySql. > My job involves to write a huge number of products codes into the > MySql, code such as: ABCDEFGHI10, it is typically between 1 million up > to 50 million codes within 1 file, which need to be uploaded/ > downloaded into MySql. > > The problem for this is it takestoo

Re: Faster Database?

2009-02-25 Thread Sebastian Bauer
W dniu 25.02.2009 11:53, bruno desthuilliers pisze: > On 25 fév, 11:00, Sean wrote: > >> Hi, >> >> I am using django+MySql. >> My job involves to write a huge number of products codes into the >> MySql, code such as: ABCDEFGHI10, it is typically between 1 million up >>

Re: Faster Database?

2009-02-25 Thread bruno desthuilliers
On 25 fév, 11:00, Sean wrote: > Hi, > > I am using django+MySql. > My job involves to write a huge number of products codes into the > MySql, code such as: ABCDEFGHI10, it is typically between 1 million up > to 50 million codes within 1 file, which need to be uploaded/ >

Faster Database?

2009-02-25 Thread Sean
Hi, I am using django+MySql. My job involves to write a huge number of products codes into the MySql, code such as: ABCDEFGHI10, it is typically between 1 million up to 50 million codes within 1 file, which need to be uploaded/ downloaded into MySql. The problem for this is it takestoo much