Subject | Re: Record numbering |
---|---|
Author | Ali Gökçen |
Post date | 2006-07-17T09:23:23Z |
Adam,
What will be broken in server or ER system theory or math?
Users cant be confused it with table columns, it is only system value
like as 'NOW', or 'USER' or CURRENT_TRANSACTION or others.
Whats is the idea/support difference between them:
select cast('NOW' as timestamp) as FETCH_TIME, id, name from foo
select CURRENT_FETCH_NUMBER, id, name from foo
what is the problem here?
client side solutions needs always more progress or education.
we may be need simple and pure selects sometimes.
if your %30 transmission time increase effects your time critical
application,
this also means you are a professional developer, and you need
client side solution for it at design time.
Regards.
Ali
> It was only a cosmetic suggest.Still i don't understand your obstinacy about this server side support.
>
> If the customer has requested it, and you have advised them that it is
> an overhead and they insist it returned by the database level rather
> than implemented at an application server. The suggestion could easily
> be implemented in the client connection components and you then have
> the best of both worlds. This is a separate issue to the business
> requirements of a customer though.
>
> Adam
>
What will be broken in server or ER system theory or math?
Users cant be confused it with table columns, it is only system value
like as 'NOW', or 'USER' or CURRENT_TRANSACTION or others.
Whats is the idea/support difference between them:
select cast('NOW' as timestamp) as FETCH_TIME, id, name from foo
select CURRENT_FETCH_NUMBER, id, name from foo
what is the problem here?
client side solutions needs always more progress or education.
we may be need simple and pure selects sometimes.
if your %30 transmission time increase effects your time critical
application,
this also means you are a professional developer, and you need
client side solution for it at design time.
Regards.
Ali