Re: Custom Row Functions: Access vs. SQL Server

lylefair wrote: 
TC wrote:


By the way, what do you say to Steve's claim that T-SQL is a performance killer?

> As you can see I did not find that the UDF was slow; in fact it may 
have had no appreciable slowdown at all [may even no slowdown at
all]. When compared with other "time" issues like the speed of data
over the wire, what other tasks the server might be performing when
you ask it to call the function etc, I think I am not going to worry
about it, barring Steve coming up with something I have overlooked.


Since Steve hasn't yet replied to this, I thought I might insert a quote
of his original assurtion to see if this helps calrify his point:

Steve Jorgensen wrote: 
On 16 Nov 2005 10:31:56 -0800, "TC" <golemdanube@xxxxxxxxx> wrote:

Steve,

Thank you for the reply.

In fact, I expressed my question badly -- I'm really interested in moving the functions to the back-end, so your comments on T-SQL are
most relevant to me. Is T-SQL really that slow? Suppose I choose
Oracle 

T-SQL is not slow in general, however scalar functions really are
that slow. It basically means you don't use scalar functions much,
> but other than that, MS SQL Server preforms quite well. 

instead; does PL-SQL have the required capabilities, and is it
faster than T-SQL?



PL-SQL does have the capabilities, and its scalar function
performance is great, but Access works slightly better with the MS
SQL Server back-end, and
you have to make sure your ODBC settings are just right, for
PostgreSQL to work correctly with Access on the front-end.


--
Bri

.

Relevant Pages

  • Re: Upsize to SQL Server
    ... I feel that with such a model, it will not be easy for me to use the power of T-SQL; I feel uneasy about interjecting an additional connection layer between the app and the db; I feel uneasy about the many posts here about problems associated with this model. ... I use T-SQL when it gives me some positive advantage over Access, enough of an advantage to justify the extra work. ... I can either use T-SQL on the server to create a view or I can write a pass-through query in Access and send raw SQL up to the server. ...
    (comp.databases.ms-access)
  • Re: db restore + transaktionsprotokoll
    ... >> angenommen der server geht kaputt. ... >> nun wie kann ich das via enterprise manager wiederherstellen? ... > verwende T-SQL. ... Dann kannst Du als Rücksicherung from ...
    (microsoft.public.de.sqlserver)
  • Re: CONTAINS "irgendwas"?
    ... Aus irgendeinem Grund kann ich nach Auswahl des fraglichen Feldes als Operator nur noch ausschließlich "contains" oder "does not contain" verwenden. ... hast Du einmal einen SQL Server Trace gestartet und beobachtet, was an den Server tatsächlich als T-SQL Statement geschickt wird, wenn Du Deine Eingaben machst. ...
    (microsoft.public.de.sqlserver)
  • Re: Problem with big data transfer
    ... DTS and T-SQL to "transfer" data from one location to ... server) and DTS for server-server transfer. ... > With more than 90000 records, the server hangs. ...
    (microsoft.public.sqlserver.clients)
  • Re: Binäre Datei per T-SQL in image-Datentyp umwandeln
    ... >> Kopie der Datei auf ein vom Server und Client erreichbares Verzeichnis ... dass es in T-SQL auch nicht vorgesehen ist. ...
    (microsoft.public.de.sqlserver)