Re: Help with recursive queries... BIG problem.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Star (----)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 17:56:11 -0500

Daniel,

Thanks a lot for your quick answer.

> I think it is. The question is if it's going to perform well enough or
not.
> SQL does not know how to deal with trees. The alternative solution is to
> load all the data into a C++ app and process the trees there.

That's something we thought about it. The problem is if we have a lot of
data.
Maybe we'd need to cache the data or something like that..

>Or put the C++
> code into an extended sprocs that executes on the SQL server side.

Yes, I did that. I use a recursive store procedure to process a tree.
However, the speed
is still very bad, if we have thousands of records.

> The other solution is to try to use the beta version of Yukon, I played
with
> it a little but I do not know how stable is. It has new features added to
> the SQL language including recursive queries. If I get the chance I'll
try
> to implement your problem in Yukon just for fun :-)

I'll take a look at that tool. I will let you know if I find out something.

Thanks a lot, Daniel

Relevant Pages

  • RE: SQL Procedure- Hierarchy listing of table content
    ... Trees in SQL: Nested Sets and Materialized Path ... Joe Celko's Trees and Hierarchies in SQL for Smarties ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL Procedure- Hierarchy listing of table content
    ... Manipulating Hierarchies with UDFs ... > Trees in SQL: ... > AMB ...
    (microsoft.public.sqlserver.programming)
  • Recursive queries?
    ... Joe Celko's Trees and hierarchies in SQL for smarties / ...
    (microsoft.public.sqlserver.programming)
  • Re: Tree ADT vs Database
    ... trees. ... I'm thinking of moving away from using trees to using a database ... As many of the posters have told you, whether a database using SQL is faster is dependent on how you plan to use and access that data. ... The extra overhead involved in doing SQL may be more time consuming than direct memory accesses involved in your own tree. ...
    (comp.lang.java.programmer)
  • Re: SQL, which items have certain refs and dont have certain other refs?
    ... >> Chapter 26, Trees, in Joe Celko's book SQL for Smarties, goes into ... I see he has since written an entire book on Trees & Hierarchies: ... "Joe Celko's Trees and Hierarchies in SQL for Smarties (Data Management ...
    (microsoft.public.fox.programmer.exchange)