Re: Disable Transaction - plans ? - Mailing list pgsql-general

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@csl.co.uk>
To: "Ben-Nes Michael" <miki@canaan.co.il>
Cc: <thomas@pgsql.com>; "Doug McNaught" <doug@wireboard.com>;
<pgsql-general@postgresql.org>; "Lee Kindness" <lkindness@csl.co.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@fourpalms.org>
>  > To: "Ben-Nes Michael" <miki@canaan.co.il>
>  > Cc: "Doug McNaught" <doug@wireboard.com>;
<pgsql-general@postgresql.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
>