Re: Disable Transaction - plans ?

Is it faster ?

Any way, less method of storing data in application the better it is.
All my old sites are on MySQL since this was the first db I was recommended
on, but when I tried Postgres I left MySQL and from then on Im using only
Postgres.

I could convert all the site for postgres but it will take too much time
which I don't have.
So currently I have two types of DB on my Server which make admin life more
difficult in many topics.
So I don't think ill add another one to make life more difficult.

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

----- Original Message -----
From: "Lee Kindness" <lkindness(at)csl(dot)co(dot)uk>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: <thomas(at)pgsql(dot)com>; "Doug McNaught" <doug(at)wireboard(dot)com>;
<pgsql-general(at)postgresql(dot)org>; "Lee Kindness" <lkindness(at)csl(dot)co(dot)uk>
Sent: Thursday, October 25, 2001 5:58 PM
Subject: Re: [GENERAL] Disable Transaction - plans ?

> What's wrong with using the appropriate tool for the task at hand? If
> you don't need the features of a database don't use one!
>
> If you've got modest DB needs look for an appropriate DB:
>
> gdbm: http://www.gnu.org/software/gdbm/
> Berkeley DB: http://www.sleepycat.com/
>
> Personally if I only had one table I'd be making my own, highly tuned,
> access routines and storage...
>
> Regards, Lee.
>
> Ben-Nes Michael writes:
> > Hi All
> >
> > If the speed will be much higher I might humbly suggest to develop two
kind
> > of tables.
> > 1. like the current one ( with great integrity )
> > 2. Like MySQL or even less sophisticated for application that need to
work
> > very fast against one table only.
> >
> > Example:
> > News page that require the most simple select ( select * from news; )
and
> > only one man update it once a day.
> > session table which require on each web page
update,insert,select,delete.
> > ( some times more then once ) especially if I store class var init.
> >
> > Think on the programing benefit and the commercial publicity Postgresql
can
> > get by telling: "we supply Oracle complexity & MySQL simplicity"
> >
> > Cheer
> >
> >
> > ----- Original Message -----
> > From: "Thomas Lockhart" <lockhart(at)fourpalms(dot)org>
> > To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
> > Cc: "Doug McNaught" <doug(at)wireboard(dot)com>;
<pgsql-general(at)postgresql(dot)org>
> > Sent: Wednesday, October 24, 2001 11:01 PM
> > Subject: Re: [GENERAL] Disable Transaction - plans ?
> >
> >
> > > ...
> > > > If the developers think that the speed increase is irrelevant then
lets
> > drop
> > > > the issue :)
> > >
> > > No problem. We will be happy to entertain patches or demonstrations
that
> > > show a clear benefit in speed for the changes you suggest.
> > >
> > > - Thomas
> > >
> > --------------------------
> > Canaan Surfing Ltd.
> > Internet Service Providers
> > Ben-Nes Michael - Manager
> > Tel: 972-4-6991122
> > http://sites.canaan.co.il
> > --------------------------
> >
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>