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
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, or
> > there is any other supe
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 M
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
tabl
> 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
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
>> to 50 million codes wit
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/
> downloaded into MySql.
>
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 time
8 matches
Mail list logo