Subject RE: [IBDI] Firebird 1
Author Paulo Gaspar
You suggest that this kind of data search trough the web is a dirty job
...but some has to do it.

Most of the data search needs could not be served by a search engine,
due to the variety of data orderings and data searching's. We are not
talking about text search ordered by rankings here.

It is funny that you _seem_ to say that an SQL database is not the
right tool to query data - what is the meaning of SQL then?


I want to use Firebird for Internet work... but what I am getting is
a lot of people saying that Firebird does not want to be an Internet
database. (Man, the Internet is really out of hype this days!)


Have fun,
Paulo Gaspar



> -----Original Message-----
> From: David Jencks [mailto:davidjencks@...]
> Sent: Friday, June 01, 2001 6:30 PM
> To: IBDI@yahoogroups.com
> Subject: Re: [IBDI] Firebird 1
>
>
> Hi,
> On 2001.06.01 10:50:03 -0400 Ann W. Harrison wrote:
> > At 01:38 PM 6/1/2001 -0700, Peter Morris wrote:
> > >So I should hold a dataset open on the server just to allow this ?
> > >Surely that is taking up more resources than I need !
> >
> > Holding a dataset open on the server is much cheaper than
> > reopening it.
> >
> >
>
> isn't this a time-space trade off?
>
> holding open on server -- holds space on server, next execution very fast
> ---perhaps most appropriate when there are few users, connected for a long
> time
>
> closing and reopening -- frees space on server, reallocated slowly on next
> execution.
> --perhaps appropriate when there are zillions of users connected for a
> short time, most of whom don't come back to reexecute.
>
> I think maybe we are asking the wrong questions here. Most of the "I want
> limit n, m no matter how slow" arguments seem to be based on the idea of
> using a rdms for a lousy web search engine, wherein you search for
> something and almost all the numerous results are totally irrelevant, so
> you have to look through pages of goo to find out you asked the wrong
> question. Perhaps a transactional resource is not the appropriate
> repository for queries of this nature. In such a situation, it hardly
> seems like you can guarantee ever showing the most appropriate
> result. How
> do web search engines work? Perhaps periodic extractions of data and using
> something like a web search engine would be more appropriate for
> applications of this kind.
>
> I think a better although perhaps harder question is, how can we show the
> user the 7+-2 items they are both interested in and can pay
> attention to at
> the same time. Then the result set is manageable and we can just return
> all the rows.
>
> david jencks
> > Regards,
> >
> > Ann
> > www.ibphoenix.com
> > We have answers.
> >
> >
> > Community email addresses:
> > Post message: IBDI@yahoogroups.com
> > Subscribe: IBDI-subscribe@yahoogroups.com
> > Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> > List owner: IBDI-owner@yahoogroups.com
> >
> > Shortcut URL to this page:
> > http://www.yahoogroups.com/community/IBDI
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
>
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>