postgres/perl, autocommit and BEGIN; COMMIT;

[Madison Kelly]

Ilya Palagin wrote:
> Madison Kelly wrote:
> 
>> Hi all,
>>
>>   I was playing more with trying to get the database performance up 
>> when I realised that I needed to "COMMIT" to aply the updates. 
>> Realising this I decided to turn postgres' 'autocommit' back off and 
>> instead use "BEGIN/COMMIT" only on the large SELECT/INPUT/UPDATE 
>> section. The problem though is that no matter what I seem to try perl 
>> throws an empty error (generic software error) whenever this call is 
>> made ($db->do("BEGIN") || die "$DBI::errstr";).
>>
>>   If I go directly into postgres and issue the same command it works 
>> fine. I've looked at the O'Reilley "Programming the Perl DBI" book and 
>> it has stuff on autocommit but it either doesn't say what I am 
>> supposed to do or I am too daft/tired to get it. Has anyone run into 
>> this before? Since turning autocommit back off my test submit of 
>> ~2,400 entires has gone up from ~21 seconds to ~99 seconds... That is 
>> a frustrating development, too say the least.
> 
> 
> Are you sure that you need PostgreSQL for your project?  MySQL is faster 
> and more simple.  It's the best choise for simple databases like yours 
> (I suppose that backup database is simple).

Fair question, and I don't know the answer :/. I chose PostgresSQL a 
while ago as my database of choice because I read of it's capabilities. 
Since then that is all I have used. Maybe when the deadline is passed I 
will try out MySQL and see how it compares.

For what it is worth, it looks like the first big user will have roughly 
5TB of data to backup and likely over a million files and directoried 
whose data needs to be saved, including unique records for what is on 
each piece of backup media. Is that "small"? (honest question). Thanks!!

Madison (Who is looking more and more like she is going to miss her 
deadline because of her lack of Javascript knowledge! >.< )
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml