Better performance in consultation with BD Oracle

Navigation
2

I am interested in finding a way to have a better performance in this scenario:

  
  • I have N stored procedures that must return the result of queries ( Select * from ... ).
    •   
  • These stored procedures are mapped with the Entity Framework. Now, to have better performance, as I advise returning the result of the query:
    •   

    At this moment 3 options come to mind

      
  • I return the results as a cursor (Throughout the network it is rumored that the cursors are bad) and so with the Entity Framework I retrieve them as List of complex self-generated classes
    •   
  • The result of the query is converted into XML and I pass it as a single XML output parameter, from the Entity Framework I retrieve that XML and I do it to a List of classes
    •   
  • I generate an algorithm to put the whole result in a single chain (or string vector) separated by PipeLine and from Entity Framework I retrieve it as a string and then, with another algorithm, take it to a List classes
    •   

    Well those options come to mind, which would be better in terms of process and performance times ?. Is there a better option that you are not considering?

    Note: I can not use LINQ because the queries do or should run in the database and through a stored procedure return the results.

        
    asked by RSillerico 10.10.2016 в 16:37
    source

    2 answers

    2

    You could try the same Entity Framework to get the information without falling into any of the methods you mention. You could guide you with the following link to StackOverflow in English: link

        
    answered by 18.10.2016 в 17:40
    1

    Another option that saved us in my work was to leave all the information in a session variable.

    In your case, if they were recurring data you could only make sure to add new information to the variable you assign to save the data.

        
    answered by 20.12.2016 в 16:13
    Error "Operand of * must be a pointer" when creating pointer with malloc and using it in a FOR Illegal character in output