Using COMMIT is only required if you issued a BEGIN TRANS before your
INSERTs, UPDATEs and / or DELETEs. All transactions are automatically
committed if you don't use BEGIN TRANS.  Are you backing up the
transaction logs regularly?

-- bob

On Fri, 16 Dec 2005, Alex Gemmell wrote:

> Hello people,
> My PHP application uses a SQL Server 2000 database.  I have previously
> only ever used MySQL and so my knowledge of SQL Server comes just from
> experimentation and trial and error experience.
> My PHP application appears to be working fine but I have just discovered
> that although the database itself is rather small on the disk (about
> 25MB) the transaction log file is huge (400MB).  I have had a quick look
> at Microsoft's website about large transaction files and they suggest
> many reasons, one of which is the application not COMMITing
> transactions.  This is certainly true because I simply make INSERT and
> UPDATE queries but don't include a COMMIT statement.
> So my question is this:  should I be COMMITing?
> How do I do that?  Do I simply run something like this after every
> mssql_query('COMMIT', $link_identifier);
> Please help - I feel like I'm missing a trick here.
> FYI:  I'm also now doubting my use of "mssql_pconnect()"  - should I
> being using "mssql_connect()" with "mssql_close()" instead?
> Thanks,
> Alex
> --
> PHP Database Mailing List (
> To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to