Databases
StackOverflow2013
Postsdbo
POStored Procedure VS. F#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POStored Procedure VS. F#
    primarykey
    data
    text
    <p>For most SP-taught developers, there are no option between Linq and Stored-Procedures/Functions. That's may be true. </p> <p>However, there are a road junctions nowadays. Before I spending too much time into syntax of F#, i would like more inputs about where the power (and opposite) of F# lies.</p> <p>How will F# perform on this topic (against SP)? </p> <p>F# have to communicate with a database on some way. Through Linq2Sql/Entity-app-layer or directly though AnyDbConnection. Nothing new there. But F# have the power of parallellism and less overhead in thier work (<a href="http://geekswithblogs.net/akraus1/articles/79880.aspx" rel="nofollow">Functional Programming with C#/F#</a>). Also F# has it's effeciency as a layer for data and machine. Pretty much like C# power of being a layer between human and machine.</p> <ul> <li>Would I really still let the DB Server handle a request of recurring nodes, or just fetch plain data to F# and handle it there? Encapsulated nice and smoothly as a object method call from C#? </li> <li>Would a stored procedure still be the best option for scanning 50 millions of records for finding orphans or a criteria that matching 0,5% of the result?</li> <li>Would a SP or function still be best for a simple task as finding next parent node?</li> <li>Would a SP still being best to collect a million records of data and return calculated sums and/or periods?</li> </ul> <p>Wouldn't a single f# dll library fully built on the Single responsibility principle being of more use then stored procedures hooked up inside a sql server? There are pros and cons, of course. But what are they?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCyril Gandon
    1. USIndependent
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POStored Procedure VS. F#
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat is "crz"? Please try to spell-check your question, if possible.
      singulars
      1. POStored Procedure VS. F#
      1. USS.Lott
    2. COYou're asking if SQL code can query a table and do aggregates? As compared to loaing 50 million rows into some F# module and doing it in the client?
      singulars
      1. POStored Procedure VS. F#
      1. USgbn
    3. COI think he does. Back in the old days there where an article about using F# to parse large xbox log files with, but that was text files and not data in a sql server. I can find this blog post: http://blogs.technet.com/b/apg/archive/2006/11/04/dealing-with-terabytes-with-f.aspx but not the original one.
      singulars
      1. POStored Procedure VS. F#
      1. USHuusom
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload