Approach question for showing big, unchanging outline

My laravel app is a big family tree website. I have Person records (id, first, last, DOB, parent_family_id, etc) and Family records (id, caption, mother_id, father_id).

Everything's done now except for my last challenge: an outline view! I have a number of 'original families' at the earliest part of the tree, and for each of them I'd like to be able to display all of their descendants all the way down to present day in an outline form (kids, those kids' families, those families' kids, etc). So far I've written a few functions:

get_kids_of_family($family)
get_families_person_made($person)
get_descendants($family, $results)- this will be a recursive function that calls get_kids_of_family, adds them to a results set (some gigantic array?), then for each of them it calls get_families_person_made, adds them to the results set, etc.

Then it occurred to me- even if I can get this working, it'll be crunching around through a lot of data, and yet this rarely changes (weekly/monthly at most, with the discovery of a new person). So I'm wondering if it makes sense to save it someplace (like an xml or json file) and somehow pass that to my view to show it instead.

Thoughts? What's a good (but not too advanced) way to implement something like this in a laravel app?

Thanks in advance for your help!

jlrdw

10 years ago

Level 75

I have actually done this. This is more of a report thing. I just selected as I went. like http://laravel.io/forum/04-04-2015-looping-through-collection I probably would use querybuilder / raw queries for progeny. I did one a number of years back that could handle 6 gen back.

make 6 temp tables to store the various results.
next you have to nest foreach through the various tables.
could store results in 6 arrays Here is one I did in VBA that is a 5 gen. Not all code shown, above is temp tables first then an individual text files, array is similar.

Private Sub REVERSE()
Open "C:\JIMPROG\PEDIGREE\G6.TXT" For Output As #2
Open "C:\JIMPROG\PEDIGREE\REVBAS.TXT" For Input As #1
Dim GEN1 As SIB1
Open "C:\ZIPFILES\GEN1.RAN" For Random As #3 Len = Len(GEN1)
Dim TN As Single
Dim V1 As String, V2 As String, V3 As String, V4 As String, V5 As String
Dim X1 As String, X2 As String, X3 As String, X4 As String
Dim LINE1 As String, TEMP As String
Dim RECGEN1 As Integer, RECGEN2 As Integer, RECGEN3 As Integer, RECGEN4 As Integer
Dim RECGEN5 As Integer
TN = 0
Do While Not EOF(1)
  TN = TN + 1
    If TN = 1 Then
      Line Input #1, LINE1
      Print #2, LINE1
    Else
      Line Input #1, LINE1
      Print #2, LINE1
    End If
Loop
Print #2, "===================================="
Close 1
V2 = ".    ."
V3 = ".    .    ."
V4 = ".    .    .    ."
V5 = ".    .    .    .    ."
For RECGEN1 = 1 To NUMGEN1
Get #3, RECGEN1, GEN1
TEMP = RTrim(GEN1.PNAME) + "," + GEN1.dogC + "," + GEN1.dogSEX + "   " + RTrim(GEN1.dogFID) + "/" + LTrim(GEN1.dogMID)
Print #2, TEMP
X1 = GEN1.dogID
 For RECGEN2 = NUMGEN1 + 1 To NUMGEN2
 Get #3, RECGEN2, GEN1
  If (GEN1.dogFID = X1 Or GEN1.dogMID = X1) Then
    TEMP = ".    ." + RTrim(GEN1.PNAME) + "," + GEN1.dogC + "," + GEN1.dogSEX + "   " + RTrim(GEN1.dogFID) + "/" + LTrim(GEN1.dogMID)
    Print #2, TEMP
    X2 = GEN1.dogID
     For RECGEN3 = NUMGEN2 + 1 To NUMGEN3
     Get #3, RECGEN3, GEN1
       If (GEN1.dogFID = X2 Or GEN1.dogMID = X2) Then
         TEMP = ".    .    ." + RTrim(GEN1.PNAME) + "," + GEN1.dogC + "," + GEN1.dogSEX + "   " + RTrim(GEN1.dogFID) + "/" + LTrim(GEN1.dogMID)
         Print #2, TEMP
         X3 = GEN1.dogID
         For RECGEN4 = NUMGEN3 + 1 To NUMGEN4
           Get #3, RECGEN4, GEN1
            If (GEN1.dogFID = X3 Or GEN1.dogMID = X3) Then
              TEMP = ".    .    .    ." + RTrim(GEN1.PNAME) + "," + GEN1.dogC + "," + GEN1.dogSEX + "   " + RTrim(GEN1.dogFID) + "/" + LTrim(GEN1.dogMID)
              Print #2, TEMP
              X4 = GEN1.dogID
              For RECGEN5 = NUMGEN4 + 1 To NUMGEN5
               Get #3, RECGEN5, GEN1
                If (GEN1.dogFID = X4 Or GEN1.dogMID = X4) Then
                  TEMP = ".    .    .    .    ." + RTrim(GEN1.PNAME) + "," + GEN1.dogC + "," + GEN1.dogSEX + "   " + RTrim(GEN1.dogFID) + "/" + LTrim(GEN1.dogMID)
                  Print #2, TEMP
                End If
              Next
            End If
          Next
       End If
     Next
  End If
 Next
Next
Reset
Command22_Click
Command12_Click
End Sub

Output like

DECENDANTS OF
SANDYLANDS TRUTH,B,F    362/48
====================================
SANDYLANDS GO JO, ,F   88/64    
.    .SANDYLANDS BE GOOD,Y,F   156/158   
.    .SANDYLANDS BLAZE,Y,M   156/158   
.    .    .AROSCAS I'M QUEENS BLAZE, ,F   157/1952  
.    .    .    .AROSCAS BLAZE GLORY, ,F   1762/1951  
.    .    .    .    .AROSCAS JOY AND GLORY,B,F   2853/1946  
.    .    .    .    .AROSCAS THE SWEDISH CONQUEROR,Y,F   1945/1946  
.    .    .SANDYLANDS BUSY LIZ,Y,F   157/160   
.    .    .    .SANDYLANDS ABBA,Y,F   86/159   
.    .    .    .    .SANDYLANDS SPECIAL SONG,Y,F   1860/1861  
.    .    .    .    .SANDYLANDS SPECIAL VINTAGE, ,F   1860/1861  
.    .    .    .SANDYLANDS RIP VAN WINKLE,Y,M   151/159   
.    .    .    .    .ALBELARM AMBRFLD S HILL PRIDE, ,F   155/2816  
.    .    .    .    .BELQUEST TO THE POINT,B,F   155/172   
.    .    .    .    .BLACKWING BALLON JUMPER,Y,F   155/1694  
.    .    .    .    .CHILBROOK SOLITAIRE,B,F   155/172   
.    .    .    .    .CIRQUES CURTAIN CALL, ,F   155/1971  
.    .    .    .    .MUSKELUNGES ONE OF A KIND,Y,F   155/2353  
.    .    .    .    .RICKWAYS TUSCAROURA, ,F   155/2659  
.    .    .    .    .SALTMEADOW BLACKWATCH,B,F   155/1448  
.    .    .    .    .U KNOW WHO OF TINTAGEL WINDS, ,F   155/1961  
.    .    .    .    .VISIONS LADY ALEXI, ,F   155/1603  
.    .    .    .SANDYLANDS STEPTOE,Y,M   234/159   
.    .    .    .SANDYLANDS STORMY WEATHER, ,M   234/159   
.    .    .    .    .ELYSIUMS THUNDERSTORM, ,F   264/233   
.    .    .SOMERSET CIDER OF KIMVALLEY, ,M   157/503   
.    .    .    .BEAVERS LAVINIA OF MOORWOOD,B,F   501/443   
.    .    .    .    .MOORWOOD JEWEL, ,F   220/200   
.    .    .    .    .MOORWOODS MADRIGAL, ,F   220/200   
SANDYLANDS GO LIGHTLY OF LONGLEY,Y,F   88/64    
.    .LONGLEY COUNT ON, ,M   156/283   
.    .    .BRAUNSPATH SIMONA OF CAMBREMER,Y,F   311/591   
.    .    .    .CAMBREMER PETROCELLI,Y,M   108/109   
.    .    .    .    .CRANSPIRE SKYTRAIN,Y,F   102/103   
.    .    .    .CAMBREMER ST. CLAIR, ,F   1497/109   
.    .    .    .    .CAMBREMER COUNTDOWN, ,F   9/1903  
.    .    .    .    .CAMBREMER MONTCLAIR, ,F   342/1903  
.    .    .    .    .CAMBREMER MR.ROSS, ,F   342/1903  
.    .    .LAWNWOODS TAMPICO,Y,F   311/141   
.    .    .    .LAWNWOODS HOT PANTS OF WARRINGAH,B,F   19/20    
.    .    .    .    .WARRINGAHS HOT DIGGORTY,Y,F   16/15    
.    .    .    .    .WARRINGAHS HOT FAVORITE,B,F   168/15    
.    .    .    .    .WARRINGAHS HOT PROPERTY, ,F   168/15    
.    .    .    .    .WARRINGAHS HOT TAFFY, ,F   16/15    
.    .    .MILK MAID OF GREENWORTH,Y,F   311/312   
.    .    .    .GREENWORTH STABLE MAID, ,F   303/304   
.    .    .    .    .SCARTHO BRIAR CREST, ,F   299/300   
.    .LONGLEY COUNTY FAIR OF JAYNCOURT, ,F   156/283   
.    .    .AJOCOS DAMN YANKEE, ,M   221/2095  
.    .    .    .DICKENDALLS SPIFFY, ,F   1418/1419  
.    .    .    .    .DICKENDALLS SNAZZY,B,F   450/461   
.    .LONGLEY IN TUNE, ,F   63/283   
.    .    .LONGLEY COME DANDY, ,M   156/154   
.    .    .    .LONGLEY BLACK TRUST OF POWHATAN,B,F   309/491   
.    .    .    .    .POWHATAN BLACK CEDAR, ,F   485/490   
.    .    .    .LONGLEY DAY BI DAY, ,M   309/310   
.    .    .    .    .GREENWORTH STABLE MAID, ,F   303/304   
.    .    .SANDYLANDS LONGLEY COME RAIN,Y,F   153/154   
.    .    .    .SANDYLANDS APRIL FOOL, ,M   86/152   
.    .    .    .    .BRADKING BRADLEY,Y,F   1390/410   
.    .    .    .    .FOXRUSH ALMOND OF ROCHEBY, ,F   1390/1902  
.    .    .    .    .FOXRUSH LICITHAS ANGEL, ,F   1390/1902  
.    .    .    .    .NOVACROFT FOOTLIGHTS, ,F   1390/2846  
.    .    .    .    .ROSEACRE PAPER FOOL, ,F   1390/1781  
.    .    .    .    .SANDYLANDS FOREVER AMBER AT TIBBLESTONE,Y,F   1390/2103  
.    .    .    .SANDYLANDS APRIL MADNESS,Y,M   86/152   
.    .    .    .    .AROSCAS BLAZE GLORY, ,F   1762/1951  
.    .    .    .    .MELLOWS SPRING MADNESS,Y,F   1762/1763  
.    .    .    .SANDYLANDS BELLA,B,F   73/152   
.    .    .    .SANDYLANDS BRAMBLE,B,F   73/152   
.    .    .    .    .SANDYLANDS MARSHAL,B,F   409/411   
.    .    .    .    .SANDYLANDS MY GUY,B,F   409/411   
.    .    .    .    .SANDYLANDS RAE, ,F   420/411   
.    .    .    .    .SANDYLANDS RHYTHM AT FOXRUSH, ,F   420/411   
.    .    .    .    .SANDYLANDS RISE AND SHINE,B,F   420/411   
.    .    .    .    .SANDYLANDS ROYAL ESCORT,Y,F   420/411   
.    .    .    .SANDYLANDS MORNING CLOUD, ,F   52/152   
.    .    .    .    .FARMER BROWN OF AYR,C,F   975/2468  
.    .    .    .SANDYLANDS MY RAINBEAU,Y,M   52/152   
.    .    .    .    .LYNDHURST RHUMBA, ,F   151/868   
.    .    .    .    .RANSOM OF SANDYLANDS,Y,F   151/421   
.    .    .    .    .SANDYLANDS RADIANCE,F,F   151/407   
.    .    .    .    .SANDYLANDS RIP VAN WINKLE,Y,F   151/159   
.    .    .    .    .SANDYLANDS ROSY,Y,F   151/407   
.    .    .    .    .SANDYLANDS ROYAL ENVOY, ,F   151/407   
.    .    .    .    .SANDYLANDS RUM BABA, ,F   151/451   
.    .    .    .SANDYLANDS NIGHT FLIGHT,B,M   1083/152   
.    .    .    .    .FAGELANGENS HAWKER HUNTER,Y,F   1773/1774  
SANDYLANDS HOLLY, ,F   938/64    
.    .SPRINGFIELDS CYMBELINE,B,F   935/2072  
.    .    .BRAEMER TOUCH STONE, ,M   19/3034  
.    .    .    .WATERBOUND STANWICKE,B,M   70/81    
.    .    .    .    .GOLDUSTS NAUGHTY NICK,Y,F   68/69    
SANDYLANDS HONOUR, ,F   938/64    
.    .SANDYLANDS WAGHORN HONESTY, ,F   63/452   
.    .    .ARDMARGHA SANDYLANDS MIRTH,B,F   52/451   
.    .    .SANDYLANDS MARKWELL OF LOCKERBIE, ,M   52/451   
.    .    .    .DICKENDALLS SNAZZY,B,F   450/461   
.    .    .    .    .DICKENDALL WATERDOG JAZZ, ,F   460/442   
.    .    .    .    .DICKENDALLS SIZZLE,B,F   219/442   
.    .    .    .DRIFTWOODS CELEBRATION, ,M   450/444   
.    .    .    .    .TABATHAS VALLEYWOOD DECOY,Y,F   437/438   
.    .    .    .ELWAY MAHOGANY,C,M   450/2238  
.    .    .    .    .MUSKELUNGES GODIVA E JANDANE, ,F   2237/2239  
.    .    .    .NORTHWOODS SANDMAN,Y,M   450/1412  
.    .    .    .    .CEDARWOOD STANDING OVATION, ,F   891/2185  
.    .    .    .    .LOBUFFS SUNDOWN AT KERRYMARK, ,F   891/1414  
.    .    .    .    .SECOND SIGHT ONYX,B,F   891/1849  
.    .    .    .WETLANDS TARA OF WHITE OAK,Y,F   450/1928  
.    .    .    .    .CHILBROOK COUNRTY SQUIRE,Y,F   1427/1927  
.    .    .SANDYLANDS MAX, ,M   52/451   
.    .    .SANDYLANDS MERCY, ,F   52/451   
.    .    .    .SANDYLANDS SOLACE AT LINERSHWOOD, ,F   865/866   
.    .    .    .    .DICKENDALLS SO FINE,Y,F   460/1604  
.    .    .    .    .LINERSHWOOD STICKY WICKET,Y,F   234/1604  
.    .    .    .    .LINERSHWOOD STORM WARNING,B,F   234/1604  
.    .    .    .SANDYLANDS SOVEREIGN OF SUDDIE,Y,M   865/866   
.    .    .    .    .CARPENNY CAMARGUE, ,F   857/858   
.    .    .    .    .CARPENNY CARMARGUE, ,F   857/858   
.    .    .    .    .FOLLYTOWER SABER,B,F   857/1451  
.    .    .    .    .FOLLYTOWER SHORTBREAD, ,F   857/1451  
.    .    .    .    .FOLLYTOWER SIR KEN, ,F   857/218   
.    .    .    .SANDYLANDS SPARKLE, ,F   865/866   
.    .    .    .    .SANDYLANDS RADIANCE,F,F   151/407   
.    .    .    .    .SANDYLANDS ROSY,Y,F   151/407   
.    .    .    .    .SANDYLANDS ROYAL ENVOY, ,F   151/407   
.    .    .SANDYLANDS RUM BABA, ,F   151/451   
.    .    .    .SANDYLANDS CLEVER CLOGGS, ,F   9/1815  
.    .    .    .    .SANDYLANDS ESCAPADE, ,F   419/1814  
SANDYLANDS KAPRICE, ,F   948/64    
.    .KENBARA JILL,Y,F   929/928   
.    .    .KIMVALLEY KENBARA MR SOFTEE, ,M   653/749   
.    .    .    .LINERSHWOOD KALAN,Y,M   927/926   
.    .    .    .SAM OF SUDDIE,Y,M   927/1638  
.    .    .    .    .SANDYLANDS SOLACE AT LINERSHWOOD, ,F   865/866   
.    .    .    .    .SANDYLANDS SOVEREIGN OF SUDDIE,Y,F   865/866   
.    .    .    .    .SANDYLANDS SPARKLE, ,F   865/866   
.    .    .    .SPRINGFIELDS SCOTTISH REEL, ,F   927/1591  
.    .    .    .    .SPRINGFIELDS BUTTER CREAM,Y,F   51/1590  
.    .    .    .    .SPRINGFIELDS BUTTERED TOAST, ,F   1592/1590  
.    .    .SPRINGFIELDS MUSETTE,Y,F   653/749   
.    .    .    .SPRINGFIELDS DINORAH,Y,F   750/748   
.    .    .    .    .INSELHEIM BRASS WIND,Y,F   746/747   
.    .    .    .    .INSELHEIM SEABROOK MIST,Y,F   746/747   
.    .    .    .    .INSELHEIMS SAVANNAH, ,F   84/747   
.    .    .    .    .SPRINGFIELDS INSELHEIM TORY, ,F   9/747   
SANDYLANDS KOMELY OF ARDMARGHA, ,F   948/64    
.    .ARDMARGHA GOLDKREST OF SYRANCOT, ,M   88/199   
.    .    .SPRINGFIELDS PICCADILLY,B,F   961/952   
.    .KILREE OF ARDMARGHA, ,F   177/199   
.    .    .ARDMARGHA LUCY LOCKET,Y,F   587/669   
.    .    .BARONOR CHARITY OF ARDMARGHA, ,F   63/669   
.    .    .    .BARONOR VESTA,Y,F   3307/3306  
.    .    .    .    .BARONOR PHOENIX, ,F   52/1765  
.    .    .FAITH OF ARDMARGHA, ,F   63/669   
.    .    .    .ARDMARGHA SO FAMOUS, ,M   234/705   
.    .    .HOPE OF ARDMARGHA,Y,F   63/669   
.    .    .    .ARDMARGHA MAD HATTER,Y,M   52/124   
.    .    .    .    .BRADKING CASSANDRA,B,F   86/87    
.    .    .    .    .BRADKING CASSIDY,Y,F   86/87    
.    .    .    .    .CROFTSPA HAZELNUT OF FOXRUSH,Y,F   86/703   
.    .    .    .    .ROSEACRE MADONNA OF TRENOW,Y,F   86/1596  
.    .    .    .    .SANDYLANDS ABBA,Y,F   86/159   
.    .    .    .    .SANDYLANDS APRIL FOOL, ,F   86/152   
.    .    .    .    .SANDYLANDS APRIL MADNESS,Y,F   86/152   
.    .    .    .KIMVALLEY GADABOUT, ,F   88/124   
.    .    .    .KIMVALLEY SWINGIN LIZZIE, ,F   88/124   
.    .    .    .    .SPRINGFIELDS SCOTTISH REEL, ,F   927/1591  
.    .    .    .KIMVALLEY WARRENTON,Y,M   88/124   
.    .    .    .    .EXMOOR DANCIN TIL DAWN,Y,F   662/2175  
.    .    .    .    .EXMOOR DOUBLE AGENT,B,F   662/2175  
.    .    .    .    .EXMOOR KERNOW DIAMOND JIM,B,F   662/2175  
.    .    .    .    .EXMOORS ON THE ORIENT EXPRESS,Y,F   662/663   
.    .    .    .    .EXMOORS OUTLAW,B,F   662/663   
.    .    .MERRY KID OF ARDMARGHA, ,F   2710/669   
.    .    .    .ARMARGHA MERRY MINX, ,F   52/2709  
.    .    .    .    .ARDMARGHA SAMSON, ,F   234/237   
SANDYLANDS MARK,B,M   161/64    
.    .ALLEGHENY BEZIQUE,B,F   52/240   
.    .    .ALLEGHENYS BABY BUNTING, ,F   220/201   
.    .    .    .ALLEGHENYS ARTFUL DODGER,B,M   1396/1397  
.    .    .ALLEGHENYS ECLIPSE,B,M   220/201   
.    .    .    .AMBLESIDE DICKENDALL BRANN, ,F   164/3342  
.    .    .    .    .DICKENDALL TIGER TOO, ,F   423/3341  
.    .    .    .AMBLESIDE MARASCHINO,Y,F   164/165   
.    .    .    .    .BORADORS RIDGEWAY REFLECTION,Y,F   128/129   
.    .    .    .DICKENDALLS MR MISTER, ,M   164/456   
.    .    .    .    .DICKENDALLS MISTERY,Y,F   455/458   
.    .    .    .GRAEMOOR CYMBIDIUM,Y,F   164/406   
.    .    .    .    .GRAEMOOR TANQUERAY,Y,F   9/405   
.    .    .    .GRAEMOOR J.SUN FARMS SASSY, ,F   164/406   
.    .    .    .    .J.SUN FARMS CEDARHILL CADET,Y,F   1852/1851  
.    .    .    .MARSHLAND BLITZ,B,M   164/227   
.    .    .    .    .BELGOLD AFTERSHOCK, ,F   219/3348  
.    .    .    .    .BORADORS DAME FORTUNE,B,F   219/2374  
.    .    .    .    .BROAD REACH MO TEE, ,F   219/2194  
.    .    .    .    .CHERRY OAKS DILLON SUNDANCE,Y,F   219/2879  
.    .    .    .    .DICKENDALL MYSTIFY,B,F   219/454   
.    .    .    .    .DICKENDALL PRESTON,B,F   219/1896  
.    .    .    .    .DICKENDALLS A-HA,B,F   219/426   
.    .    .    .    .DICKENDALLS DAZZLE, ,F   219/459   
.    .    .    .    .DICKENDALLS SIZZLE,B,F   219/442   
.    .    .    .    .GOLD STRIKES STEEL MAGNOLIA, ,F   219/2879  
.    .    .    .    .GRAEMOOR TIM,B,F   219/404   
.    .    .    .    .KILIJA BRIGAND,B,F   219/3324  
.    .    .    .    .MARSHLAND GLITZ, ,F   219/3771  
.    .    .    .    .ROCKY ACRES BIT OF LACE,Y,F   219/426   
.    .    .    .    .VALLEYWOOD NIGHTHAWK,B,F   219/743   
.    .    .    .    .WELLY BOBS BLACK TUXEDO,B,F   219/2347  
.    .    .    .PENELOPE OF BELNABOTH,Y,F   164/1274  
.    .    .    .    .BELNABOTHS BLACK PATRICK,B,F   427/1275  
.    .    .    .    .BELNABOTHS TOM OF EDGEWOOD,B,F   427/1275  
.    .    .ALLEGHENYS MCDUFF,B,M   72/201   
.    .    .    .DAYLIGHTS BLACKTHORN BARON,B,M   629/630   
.    .    .    .    .DAYLIGHTS MIDNIGHT RAIDER,B,F   625/626   
.    .    .ALLEGHENYS MCTAVISH, ,M   72/201   
.    .    .    .BOROWICK MIDNIGHT LACE, ,F   1973/1974  
.    .    .    .    .BOROWICKS BEATRIX, ,F   1969/1970  
.    .    .    .BOROWICKS CELEBRITY, ,F   1973/1974  
.    .    .    .    .BOROWICKS WINNING COLOURS,B,F   2382/2376  
.    .    .ALLEGHENYS TWILIGHT, ,F   220/201   
.    .    .    .ALLEGHENYS FITZWILLIAM, ,M   1398/1399  
.    .    .    .    .ALLEGHENYS ARTFUL DODGER,B,F   1396/1397  
.    .    .    .ALLEGHENYS PEPPERCORN, ,F   2650/1399  
.    .    .    .    .ALLEGHENYS PICCALILLY, ,F   2648/2649  
.    .ARDMARGHA MAD HATTER,Y,M   52/124   
.    .    .BRADKING CASSANDRA,B,F   86/87    
.    .    .    .BRADKING BEVERLY,C,F   342/343   
.    .    .    .    .HENNINGS MILL CALYPSO BEAUTY,C,F   339/341   
.    .    .    .    .HENNINGS MILL CHARMING BEAUTY,B,F   338/341   
.    .    .    .    .HENNINGS MILL MASTER BLEND,C,F   247/341   
.    .    .    .    .HENNINGS MILL RAMBLIN COMIC,C,F   2416/341   
.    .    .    .    .HENNINGS MILLS BROWN KING,C,F   247/341   
.    .    .    .    .HENNINGS MILLS COURT BEAUTY, ,F   696/341   
.    .    .    .    .HENNINGS MILLS MASTER BLEND,C,F   247/341   
.    .    .    .    .HENNINGS MILLWILL COPPERTONE,C,F   2416/341   
.    .    .    .BRADKING BRIDGETTE OF DAVRICARD, ,F   342/343   
.    .    .    .LILLIMARS MOONBEAM,B,M   342/343   
.    .    .BRADKING CASSIDY,Y,M   86/87    
.    .    .    .BALRION LADY OF FASHION, ,F   82/418   
.    .    .    .    .KELLEYGREEN HEADING WEST,Y,F   1427/1428  
.    .    .    .    .KELLEYGREENS BANNER DAY, ,F   696/1428  
.    .    .    .    .KELLEYGREENS ON TARGET,Y,F   1427/1428  
.    .    .    .BALRION LADY OF LEASURE,Y,F   82/418   
.    .    .    .    .BALRION BOWLED OVER,B,F   415/417   
.    .    .    .BALRION MAN OF THE MOMENT, ,M   82/418   
.    .    .    .    .BALRION EDGE OF DARKNESS, ,F   3026/2272  
.    .    .    .    .BALRION MAID TO MATCH,B,F   3026/3027  
.    .    .    .BRADKING RANGEWAYS MR. CHIPS,Y,M   82/83    
.    .    .    .    .CHABLAIS CROUSTILLE,B,F   79/1687  
.    .    .    .    .CHABLAIS RIGODON,B,F   79/1687  
.    .    .    .    .CHOCORUA ON DECK AT BELQUEST,Y,F   79/80    
.    .    .    .    .CHOCORUA SEAWORTHY OF BELQUEST,Y,F   79/80    
.    .    .    .    .CROFTSPA CHINATEA, ,F   79/703   
.    .    .    .    .HILLTOP COUNTRYSIDE BARN BURNER,C,F   79/3319  
.    .    .    .    .RANBOURNE THIS BUDS FOR YOU,B,F   79/1489  
.    .    .    .    .SHADOWVALE MINSTRAL BLACK VELVET, ,F   79/739   
.    .    .    .CAPTAIN KIRK OF RANGEWAYS, ,M   82/3220  
.    .    .    .    .DONALBAIN MUSTARDSEED, ,F   3218/3219  
.    .    .    .HEATHERBOURNE COURT JESTER, ,M   82/1384  
.    .    .    .    .CRICKLECREEK CALYPSO, ,F   718/1700  
.    .    .    .    .HEATHERBOURNE CLANSMAN,Y,F   718/1853  
.    .    .    .    .JAYNCOURT JINGLE JANGLE, ,F   718/724   
.    .    .    .KEYSUN RIPPLING WIND, ,M   82/3022  
.    .    .    .    .BAYSIDES MARK WEST,B,F   3021/3020  
.    .    .    .KEYSUN RULING STAR OF BRADKING, ,F   82/1387  
.    .    .    .    .BRADKING BRADLEY,Y,F   1390/410   
.    .    .    .    .BRADKING MIKE,B,F   409/410   
.    .    .CROFTSPA HAZELNUT OF FOXRUSH,Y,F   86/703   
.    .    .ROSEACRE MADONNA OF TRENOW,Y,F   86/1596  
.    .    .    .TRENOW MINUET,Y,F   168/864   
.    .    .    .    .TRENOW BRIAR ROSE, ,F   855/856   
.    .    .    .    .TRENOW BRIGADIER,Y,F   855/856   
.    .    .    .TRENOW MUSIC MAN,B,M   168/864   
.    .    .    .    .CARPENNY MULSANNIE, ,F   1595/1753  
.    .    .    .    .MONEY SPINNER FOR CORNLANDS, ,F   1595/3096  
.    .    .    .    .TRENOW MINSTREL,B,F   1595/2187  
.    .    .SANDYLANDS ABBA,Y,F   86/159   
.    .    .    .SANDYLANDS SPECIAL SONG,Y,F   1860/1861  
.    .    .    .    .SANDYLANDS GENTRY,B,F   1857/1859  
.    .    .    .    .SANDYLANDS OBSESSION,Y,F   691/1859  
.    .    .    .SANDYLANDS SPECIAL VINTAGE, ,M   1860/1861  
.    .    .    .    .FOXRUSH STRAWBERRY FIZZ,Y,F   2317/2318  
.    .    .SANDYLANDS APRIL FOOL, ,M   86/152   
.    .    .    .BRADKING BRADLEY,Y,M   1390/410   
.    .    .    .FOXRUSH ALMOND OF ROCHEBY, ,F   1390/1902  
.    .    .    .    .ROCHEBY COUNTRY MAID OF AMESLEAGH, ,F   1905/1901  
.    .    .    .    .ROCHEBY GINGERNUT,Y,F   691/1901  
.    .    .    .FOXRUSH LICITHAS ANGEL, ,F   1390/1902  
.    .    .    .    .LICITHAS BACCHUS, ,F   3508/3509  
.    .    .    .NOVACROFT FOOTLIGHTS, ,F   1390/2846  
.    .    .    .    .NOVACROFT MAGNUM, ,F   1857/2844  
.    .    .    .ROSEACRE PAPER FOOL, ,M   1390/1781  
.    .    .    .    .SENDERBRAYKE ALACRITY,B,F   1779/1776  
.    .    .    .SANDYLANDS FOREVER AMBER AT TIBBLESTONE,Y,F   1390/2103  
.    .    .    .    .TIBBLESTONE THE CHORISTER, ,F   2105/2107  
.    .    .SANDYLANDS APRIL MADNESS,Y,M   86/152   
.    .    .    .AROSCAS BLAZE GLORY, ,F   1762/1951  
.    .    .    .    .AROSCAS JOY AND GLORY,B,F   2853/1946  
.    .    .    .    .AROSCAS THE SWEDISH CONQUEROR,Y,F   1945/1946  
.    .    .    .MELLOWS SPRING MADNESS,Y,F   1762/1763  
.    .    .    .    .MELLOWS BLONDE MAGIC,Y,F   1760/1761  
.    .ARDMARGHA SANDYLANDS MIRTH,B,F   52/451   
.    .ARMARGHA MERRY MINX, ,F   52/2709  
.    .    .ARDMARGHA SAMSON, ,M   234/237   
.    .    .    .BOLD AARON,Y,M   230/2644  
.    .    .    .    .HYGATE GINGER,Y,F   2643/2640  
.    .    .    .    .PROSPECTS FIRE AND REIGN, ,F   2643/2804  
.    .    .    .HAWKETT PAISLEY AMBER BREEZE,Y,F   230/231   
.    .    .    .    .MARSHLAND PAISLEY BROONE,Y,F   228/229   
.    .    .    .JASERIES GOLD HILL THUNDER,Y,M   230/880   
.    .    .    .    .LUCKY FOUR FINNIGAN O RIAGAIN,Y,F   875/876   
.    .    .    .SADDLEHILL PROMISE, ,F   230/3670  
.    .    .    .    .SADDLEHILL OBRIENS RAPPAREE, ,F   3665/3666  
.    .BALLYDUFF MARKETEER,B,M   52/95    
.    .    .ASTONBROOK CRUSADER,Y,M   17/1756  
.    .    .    .JOLINE INKLING OF FOLLYTOWER,B,M   862/863   
.    .    .    .    .TRENOW BRIAR ROSE, ,F   855/856   
.    .    .    .    .TRENOW BRIGADIER,Y,F   855/856   
.    .    .BALLYDUFF MARSALA, ,F   17/1068  
.    .    .    .HUNTSDOWN MARIMBA, ,F   1033/2011  
.    .    .    .    .HUNTSDOWN COACHLIGHT,B,F   2012/2009  
.    .    .BRYNDAFYDD ADONIS OF FESERWICK, ,M   17/18    
.    .    .    .WARRINGAHS HOT DIGGORTY,Y,M   16/15    
.    .    .    .    .BEAUTAWNS CAPT.DIGGORITY,B,F   4/5     
.    .    .    .    .HARBORTOPS AUGUST KNIGHT,B,F   4/1422  
.    .    .    .WARRINGAHS HOT TAFFY, ,F   16/15    
.    .    .    .    .WARRINGAHS FAIR DINKUM, ,F   1463/1462  
.    .    .CURNEFANE SAM OF BALLYDUFF,B,M   17/2116  
.    .    .    .CURNEFANE STRIKE,B,F   538/537   
.    .    .    .    .MALLARDS CLAY BASKER,B,F   531/532   
.    .    .FOLLYTOWER BANDBOX, ,F   17/863   
.    .    .    .FOLLYTOWER KATE, ,F   1450/1451  
.    .    .    .    .FOLLYTOWER BLACKBERRY,B,F   316/1449  
.    .    .    .    .FOLLYTOWER FORTUNA AT CORNELLY, ,F   1495/1449  
.    .    .    .FOLLYTOWER SABER,B,M   857/1451  
.    .    .    .    .SPRINGFIELDS BEVERAGE,B,F   3040/3042  
.    .    .    .FOLLYTOWER SHORTBREAD, ,F   857/1451  
.    .    .JAYNCOURT AJOCO JUSTICE,B,M   17/345   
.    .    .    .ANDERSCROFT MIJANS BRAVO,B,M   344/752   
.    .    .    .    .INSELHEIM BRASS WIND,Y,F   746/747   
.    .    .    .    .INSELHEIM SEABROOK MIST,Y,F   746/747   
.    .    .    .    .MEADOWMERES COASTAL CRUISER, ,F   746/1924  
.    .    .    .    .TERACROFT KER-SPLASH,B,F   746/2513  
.    .    .    .    .VALLEYWOOD CLASSIQUE GEM,Y,F   746/1692  
.    .    .    .    .WATERDOGS RAINE DANCER,B,F   746/1092  
.    .    .    .BEECHCROFTS DOVER,B,M   344/431   
.    .    .    .    .ALIHO DENALI COALER,B,F   686/597   
.    .    .    .    .ALIHOS CASEY OF LAKE CREEK, ,F   686/597   
.    .    .    .    .BEECHCROFTS CLOVER OF O HENRY,B,F   686/1060  
.    .    .    .    .GREEN VALLEYS CAROLINA MIST, ,F   686/1808  
.    .    .    .    .WINTERSET MAGIC DOVE, ,F   686/3480  
.    .    .    .BEECHCROFTS MEADOWLARK,B,F   344/431   
.    .    .    .    .BEECHCROFTS DANISH CHEER,B,F   722/552   
.    .    .    .    .BEECHCROFTS MEADOWSONG,B,F   1423/552   
.    .    .    .    .BEECHCROFTS WINDSLOW,B,F   551/552   
.    .    .    .BEECHCROFTS SKYLARK,B,F   344/431   
.    .    .    .    .BEECHCROFT SPRINGWINDS JET,B,F   684/723   
.    .    .    .    .BEECHCROFTS BREEZY, ,F   551/723   
.    .    .    .    .BEECHCROFTS C BROOK SEAWORTHY,B,F   1032/723   
.    .    .    .    .BEECHCROFTS DANISH SKYDIVER,B,F   722/723   
.    .    .    .    .HIGHTIDES CANADIAN RUST, ,F   722/723   
.    .    .    .FINCHINGFIELD CAPRICIOUS, ,F   344/1433  
.    .    .    .    .WENWOODS BANNER RUBY BEGONIA, ,F   2198/2199  
.    .    .    .FINCHINGFIELD CELTIC CAPER,B,M   344/1433  
.    .    .    .    .DANICKS BLACK MAGIC II,B,F   1432/3001  
.    .    .    .FINCHINGFIELD MIGHTY CASEY,B,M   344/1433  
.    .    .    .    .VAUGHNS KERRY BRIARGLEN, ,F   2192/1932  
.    .    .    .MIJANS ALL THAT JAZZ, ,F   344/752   
.    .    .    .    .MIJANS TOO HOT TO HANDLE, ,F   1095/1093  
.    .    .    .RAINELLS DYNASTY,B,M   344/2193  
.    .    .    .    .BREEZYS CYCLONE,Y,F   1935/2658  
.    .    .    .    .BRIARGLENS PAISLEY TAIN,Y,F   1935/1933  
.    .    .    .    .BUTTONW OOD PEPITA, ,F   1935/3738  
.    .    .    .    .STONECREST STAR OF INDIA,B,F   1935/2660  
.    .    .    .SEABROOK INSELHEIM JEST,B,F   344/744   
.    .    .    .    .INSELHEIM JUST JOKIN,B,F   1993/1420  
.    .    .    .SHADOWVALE JUST SO, ,F   344/346   
.    .    .    .    .TWEEDCROFTS DEBONAIR, ,F   1090/1897  
.    .    .    .    .TWEEDCROFTS REFLEXION, ,F   9/1897  
.    .    .    .SHADOWVALES JILL AT RAMBOURNE,B,F   344/346   
.    .    .    .    .RANBOURNE THIS BUDS FOR YOU,B,F   79/1489  
.    .    .    .SHADOWVALES JUST A LOVE SONG, ,F   344/346   
.    .    .    .    .CIRQUES CURTAIN CALL, ,F   155/1971  
.    .    .    .SHADOWVALES JUST REWARD,Y,M   344/346   
.    .    .    .    .BEAUTAWNS IMPORTER,Y,F   353/349   
.    .    .    .    .BEAUTAWNS INSIDE INFORMATION,Y,F   353/349   
.    .    .    .SPIRITWOOD ZIPCODE BELQUEST, ,F   344/402   
.    .    .    .    .BELQUEST UNCHARTERED SEAS, ,F   122/401   
.    .    .    .SPRINGFIELDS BLACK ROD,B,M   344/1589  
.    .    .    .    .CHILLYBLEAK HILLTOP ANNIE,Y,F   1588/2932  
.    .    .    .VALLEYWOODS JUSTIN CASE,Y,M   344/431   
.    .    .    .    .BORADORS CARNIVAL STAR,B,F   2352/0     
.    .    .    .    .MUSKELUNGES LISAS LADY, ,F   2352/2351  
.    .    .    .    .VALLEYWOOD DICKENS,B,F   2352/2496  
.    .    .    .VALLEYWOODS KANNONBALL KATE,F,F   344/431   
.    .    .    .    .TABATHAS CORKER O VALLEYWOOD,B,F   339/438   
.    .    .    .    .TABATHAS VALLEYWOOD DECOY,Y,F   437/438   
.    .    .    .    .VALLEYWOOD PISTOL PETE,Y,F   696/438   
.    .    .    .    .VALLEYWOODS ROMANY RIANNON, ,F   339/438   
.    .    .KUPROS BRIDGET, ,F   17/216   
.    .    .    .FOLLYTOWER BROWNTHORN, ,F   204/215   
.    .    .    .    .FOLLYTOWER BRAZEN OF MERRYMILLS, ,F   409/483   
.    .    .    .KUPROS MAJOR AT LINDALL,B,M   204/215   
.    .    .    .    .LINDALL CLASSIC,C,F   397/206   
.    .    .    .    .LINDALL LOVE IS, ,F   397/720   
.    .    .    .KUPROS MARSHALL,B,M   204/215   
.    .    .    .    .AQUADOTS GOOD GOLLY MISS MOLLY,B,F   1458/2869  
.    .    .    .    .CAMPBELLCROFTS BANKS,B,F   1458/3553  
.    .    .    .KUPROS MASTER MARINER,B,M   204/215   
.    .    .    .    .ALLENIES MARCHIONESS, ,F   409/1844  
.    .    .    .    .BELTARN DIUMA OF NEWINN, ,F   409/2858  
.    .    .    .    .BLACKFRIARS BYZANCE, ,F   409/481   
.    .    .    .    .BOOTHGATES CRAZY KAPER, ,F   409/2557  
.    .    .    .    .BRADKING MIKE,B,F   409/410   
.    .    .    .    .CAMBREMER ALL THAT JAZZ, ,F   409/1938  
.    .    .    .    .CAMBREMER CLASSICAL JAZZ, ,F   409/1938  
.    .    .    .    .CAMBREMER COPY CAT, ,F   409/1938  
.    .    .    .    .CAMBREMER DU VALLON DE VILLIARD, ,F   409/1938  
.    .    .    .    .CAMBREMER JAZZ SINGER,B,F   409/1938  
.    .    .    .    .CANNONRIDGE JACKDAW, ,F   409/2524  
.    .    .    .    .CHARWAY MAVERICK,B,F   409/248   
.    .    .    .    .DAVRICARD BOBBY SHAFTO,B,F   409/1868  
.    .    .    .    .FOLLYTOWER BRAZEN OF MERRYMILLS, ,F   409/483   
.    .    .    .    .JAYNCOURT THE PROFESSOR,B,F   409/762   
.    .    .    .    .LASGARN LAUDRUP, ,F   409/2190  
.    .    .    .    .LOUGIN NUT CLUSTER,C,F   409/3724  
.    .    .    .    .NAIKEN EDUARDO ESQUIRE,C,F   409/3697  
.    .    .    .    .PRIMSLAND MATCH MAKER AT KUPROS,B,F   409/3315  
.    .    .    .    .ROCHEBY ROYAL MARINE,B,F   409/1863  
.    .    .    .    .ROCHEBY SAILING ALONG AT FOLLYTOWER, ,F   409/1863  
.    .    .    .    .ROCHEBY SAILING BY, ,F   409/1863  
.    .    .    .    .SANDYLANDS MARSHAL,B,F   409/411   
.    .    .    .    .SANDYLANDS MY GUY,B,F   409/411   
.    .    .    .    .SUNNYDAZE AT LAKEVIEW, ,F   409/3702  
.    .    .    .KUPROS MIDNIGHT FROLIC, ,F   204/215   
.    .    .    .    .ALLEGHENYS BRAMBLE, ,F   72/1415  
.    .    .    .    .LABWELLS RATHAMILL RAVEN,B,F   72/1415  
.    .    .MARBRA RHAPSODY, ,F   17/2400  
.    .    .    .MARBRA GUARDSMAN, ,M   2396/2397  
.    .    .    .    .SIMMERDOWN BRANDYWINE, ,F   2297/892   
.    .    .    .    .SIMMERDOWNS GAME TYME, ,F   2297/2298  
.    .    .MARTIN OF BALLYDUFF,B,M   17/93    
.    .    .    .BEECHCROFTS BREEZY, ,F   551/723   
.    .    .    .    .COLTONS AGAINST THE WIND,B,F   1447/1988  
.    .    .    .    .COLTONS CALVIN BLACK,B,F   427/1988  
.    .    .    .BEECHCROFTS WINDSLOW,B,M   551/552   
.    .    .    .    .SPRINGWINDS POT OHONEY,B,F   508/509   
.    .    .    .TABATHAS CHAOS,B,F   551/1080  
.    .    .    .TABATHAS SPARKLER,B,F   551/1080  
.    .    .    .    .TABATHAS GLITTER, ,F   2334/2335  
.    .    .    .    .TABATHAS LINDY, ,F   435/2335  
.    .    .    .    .TABATHAS REVELRY, ,F   132/2335  
.    .    .    .    .TABATHAS SPECIAL BANNER, ,F   2334/2335  
.    .    .    .TABATHAS UP'N'AT'EM OF LIN-RAY,B,M   551/1080  
.    .    .    .    .WINDFALL HURRICANE KARLA, ,F   1579/1977  
.    .    .    .WYNDCALLS DRUID O'TABATHA,B,M   551/1080  
.    .    .    .    .TABATHA BOROWICK SHOOTER, ,F   1406/436   
.    .    .    .    .TABATHAS RAMSEY OF BLACKAMOOR,B,F   1406/436   
.    .    .MARTIN OF MARDAS, ,M   17/1067  
.    .    .    .FABRACKEN COMEDY STAR,B,M   333/334   
.    .    .    .    .BRADKING BEVERLY,C,F   342/343   
.    .    .    .    .BRADKING BRIDGETTE OF DAVRICARD, ,F   342/343   
.    .    .    .    .CAMBREMER MONTCLAIR, ,F   342/1903  
.    .    .    .    .CAMBREMER MR.ROSS, ,F   342/1903  
.    .    .    .    .CHARWAY MATTIE BROWN, ,F   342/208   
.    .    .    .    .CHARWAY SEASHELL, ,F   342/208   
.    .    .    .    .CRANSPIRE AYANEE,B,F   342/103   
.    .    .    .    .HAVERTON TAWNY PIPPET AT BRIGBURN, ,F   342/3211  
.    .    .    .    .LILLIMARS MOONBEAM,B,F   342/343   
.    .    .    .    .LINDALL MOLLIE MALONE, ,F   342/206   
.    .    .    .    .POOLSTEAD PICK ME UP, ,F   342/1835  
.    .    .    .    .POOLSTEAD PICK OF THE POPS,B,F   342/1835  
.    .    .    .    .SULEYS SATAN BUG,B,F   342/1825  
.    .    .    .MARDAS GRANDE MARQUIS,B,M   333/1068  
.    .    .    .MARDAS MASTER MARINER, ,M   333/1068  
.    .    .    .    .MARDAS MARITIME MAN, ,F   2028/2029  
.    .    .    .    .MARDAS MIGNONETTE OF TIMSPRING,B,F   2028/2937  
.    .    .    .MISS JENNA OF MARDAS, ,F   333/1964  
.    .    .    .    .MARDAS SAPHIRE, ,F   1957/1958  
.    .    .    .ROCHEBY DARK EBONY,B,F   333/872   
.    .    .    .    .ROCHEBY POLISHED OAK, ,F   480/861   
.    .    .PASSINGRIDGE MAGEN, ,F   17/137   
.    .    .    .PASSINGRIDGE BLACK PRINCE,B,M   112/1403  
.    .    .    .    .BEECHCROFTS DANISH CHEER,B,F   722/552   
.    .    .    .    .BEECHCROFTS DANISH SKYDIVER,B,F   722/723   
.    .    .    .    .HIGHTIDES CANADIAN RUST, ,F   722/723   
.    .    .PENDIL OF BALLYDUFF,Y,M   17/93    
.    .    .    .INGMOS UMBERTO,B,M   523/524   
.    .    .    .    .ROSANAN DANDELION,B,F   520/521   
.    .    .ROSEACRE SHELL,Y,F   17/1597  
.    .    .    .ROSEACRE MADONNA OF TRENOW,Y,F   86/1596  
.    .    .    .    .TRENOW MINUET,Y,F   168/864   
.    .    .    .    .TRENOW MUSIC MAN,B,F   168/864   
.    .    .    .ROSEACRE STATE SECRET, ,F   1614/1596  
.    .    .    .    .SENDERBRAYKE ALACRITY,B,F   1779/1776  
.    .    .ROYDWOOD REMARK, ,F   17/1583  
.    .    .    .STRINESDALE BLACK ROD,B,M   1584/1582  
.    .    .    .    .BEECHCROFT WREN OF SHADOWGLEN,Y,F   1581/431   
.    .    .    .    .WYNTERCREEK BUTTER CREAM, ,F   1581/3668  
.    .    .SPARK OF BALLYDUFF,B,F   17/93    
.    .    .    .BALLYDUFF BALLAD,B,F   210/211   
.    .    .    .    .BALLYDUFF JOHN BULL,B,F   557/558   
.    .    .    .    .BALLYDUFF JOHNSON,B,F   557/558   
.    .    .    .BALLYDUFF FERGUS,B,M   210/211   
.    .    .    .    .MALLARDS ELI THE BOAT,B,F   492/544   
.    .    .    .    .MALLARDS MINNOW POPPER,B,F   492/1620  
.    .    .    .    .MALLARDS PEEPER POPPER, ,F   492/1602  
.    .    .    .    .MALLARDS SANDY EEL,B,F   492/1061  
.    .    .    .    .MALLARDS VINTER O HENRY,B,F   492/1061  
.    .    .    .    .WILLOWS EMILIA, ,F   492/493   
.    .    .    .BALLYDUFF LARK,B,F   210/211   
.    .    .    .    .BEECHCROFT WREN OF SHADOWGLEN,Y,F   1581/431   
.    .    .    .    .BEECHCROFTS DOVER,B,F   344/431   
.    .    .    .    .BEECHCROFTS EDGEWOOD TOMARC,B,F   430/431   
.    .    .    .    .BEECHCROFTS MEADOWLARK,B,F   344/431   
.    .    .    .    .BEECHCROFTS SKYLARK,B,F   344/431   
.    .    .    .    .HUNTSDOWN VALLEYWOOD SPICE,Y,F   265/431   
.    .    .    .    .VALLEYWOOD GENUINE APPEAL, ,F   430/431   
.    .    .    .    .VALLEYWOODS JUSTIN CASE,Y,F   344/431   
.    .    .    .    .VALLEYWOODS KANNONBALL KATE,F,F   344/431   
.    .    .    .BALLYDUFF SPARKLER, ,F   210/211   
.    .    .    .    .ROCKY ACRES SULTAN OF AYR,B,F   166/1642  
.    .    .    .BALLYDUFF SPRUCE,B,M   210/211   
.    .    .    .    .CHARWAY BALLYWILLWILL,B,F   207/208   
.    .    .SQUIRE OF BALLYDUFF,B,M   17/93    
.    .    .    .BALLYDUFF KALI,B,F   73/1660  
.    .    .    .    .KERRYMARK BLACKAMOOR FLINT,B,F   293/1659  
.    .    .    .EDUNY JUBILEE SQUIRE,Y,M   73/266   
.    .    .    .    .HUNTSDOWN VALLEYWOOD SPICE,Y,F   265/431   
.    .    .    .KUPROS LADYS PRIDE, ,F   73/74    
.    .    .    .    .KUPROS BRIDGET, ,F   17/216   
.    .    .    .KUPROS LIVE SPARK,B,M   73/74    
.    .    .    .    .ALLEGHENYS BRAMBLE, ,F   72/1415  
.    .    .    .    .ALLEGHENYS MCDUFF,B,F   72/201   
.    .    .    .    .ALLEGHENYS MCTAVISH, ,F   72/201   
.    .    .    .    .CHILBROOK BRIGADIER DYNAMO,B,F   72/77    
.    .    .    .    .LABWELLS RATHAMILL RAVEN,B,F   72/1415  
.    .    .    .KUPROS SPARTACUS,B,M   73/1402  
.    .    .    .    .KILLINGWORTH BORADOR TRAVIS,B,F   166/167   
.    .    .    .    .KILLINGWORTH ROSEY TOMARROWS,B,F   166/2345  
.    .    .    .    .KILLINGWORTHS WELLYBOB KERRY,B,F   166/2599  
.    .    .    .    .MCDERRYS CREOSOTE, ,F   166/1914  
.    .    .    .    .ROCKY ACRES SULTAN OF AYR,B,F   166/1642  
.    .    .    .    .TABATHAS REMARQUE O CITADEL,B,F   166/1080  
.    .    .    .KUPROS SPRING FOLLY OF WETHERLAM, ,F   73/1402  
.    .    .    .    .WETHERLAM STORM OF LAWNWOOD, ,F   869/1467  
.    .    .    .KUPROS STARSHINE,B,F   73/1402  
.    .    .    .PASSINGRIDGE SEAMSTRESS OF BRYNDAFYDD, ,F   73/3171  
.    .    .    .    .BRYNDAFYDD KLIO, ,F   2021/3170  
.    .    .    .RODARBAL RULER,B,M   73/2110  
.    .    .    .    .ALVGARDENS VALLE,B,F   2433/2434  
.    .    .    .SANDYLANDS BELLA,B,F   73/152   
.    .    .    .SANDYLANDS BRAMBLE,B,F   73/152   
.    .    .    .    .SANDYLANDS MARSHAL,B,F   409/411   
.    .    .    .    .SANDYLANDS MY GUY,B,F   409/411   
.    .    .    .    .SANDYLANDS RAE, ,F   420/411   
.    .    .    .    .SANDYLANDS RHYTHM AT FOXRUSH, ,F   420/411   
.    .    .    .    .SANDYLANDS RISE AND SHINE,B,F   420/411   
.    .    .    .    .SANDYLANDS ROYAL ESCORT,Y,F   420/411   
.    .BALLYDUFF MAROON, ,M   52/95    
.    .    .MALLARDS DEEP PURPLE, ,F   1065/545   
.    .    .    .MALLARDS SANDY EEL,B,F   492/1061  
.    .    .    .    .MALLARDS CADDIS WORM,B,F   540/1475  
.    .    .    .    .MALLARDS NORWEGIAN SWEET, ,F   522/1475  
.    .    .    .MALLARDS VINTER O HENRY,B,F   492/1061  
.    .    .    .    .BEECHCROFTS CLOVER OF O HENRY,B,F   686/1060  
.    .BALLYDUFF MORELLA, ,F   52/95    
.    .    .KUPROS KIRSH, ,F   104/94    
.    .    .    .KUPROS SPARTACUS,B,M   73/1402  
.    .    .    .    .KILLINGWORTH BORADOR TRAVIS,B,F   166/167   
.    .    .    .    .KILLINGWORTH ROSEY TOMARROWS,B,F   166/2345  
.    .    .    .    .KILLINGWORTHS WELLYBOB KERRY,B,F   166/2599  
.    .    .    .    .MCDERRYS CREOSOTE, ,F   166/1914  
.    .    .    .    .ROCKY ACRES SULTAN OF AYR,B,F   166/1642  
.    .    .    .    .TABATHAS REMARQUE O CITADEL,B,F   166/1080  
.    .    .    .KUPROS SPRING FOLLY OF WETHERLAM, ,F   73/1402  
.    .    .    .    .WETHERLAM STORM OF LAWNWOOD, ,F   869/1467  
.    .    .    .KUPROS STARSHINE,B,F   73/1402  
.    .    .KUPROS MARCIA OF BLONDELLA, ,F   40/94    
.    .    .    .BLONDELLA MOLLYWOG,B,F   845/846   
.    .    .    .    .BARNABY OF CHARWAY,B,F   205/844   
.    .    .    .    .BLONDELLA BALLERINA, ,F   205/844   
.    .    .    .    .BLONDELLA BALLERITA, ,F   205/844   
.    .    .    .    .BLONDELLA BALLYWHO,B,F   205/844   
.    .    .    .    .SHADES OF BLONDELLA, ,F   204/844   
.    .    .KUPROS MARYLLA, ,F   40/94    
.    .    .    .LONGLEY BLACK TRUST OF POWHATAN,B,F   309/491   
.    .    .    .    .POWHATAN BLACK CEDAR, ,F   485/490   
.    .    .KUPROS MOONRIVER OF FOLLYTOWER, ,F   40/94    
.    .    .    .FOLLYTOWER MASTER BROWN OF CHARWAY,C,M   204/218   
.    .    .    .    .CHILBROOK KEEPSAKE MARCUS,B,F   217/290   
.    .    .    .    .CHILBROOK MANHATTAN,B,F   217/290   
.    .    .    .    .CHILBROOK MISS CHATELAINE,C,F   217/290   
.    .    .    .FOLLYTOWER SIR KEN, ,M   857/218   
.    .    .    .    .FOLLYTOWER KATE, ,F   1450/1451  
.    .    .    .FOLLYTOWER WIDGEN OF BALLYDUFF, ,F   205/218   
.    .    .    .    .BALLYDUFF KALI,B,F   73/1660  
.    .    .    .FOLLYTOWER WILLOW, ,F   205/218   
.    .    .    .    .FOLLYTOWER LEWIS, ,F   2188/477   
.    .    .    .    .FOLLYTOWER MAN O'WAR, ,F   476/477   
.    .    .KUPROS MR MAGIC, ,M   40/94    
.    .    .    .BRIARY MAEVE, ,F   1486/638   
.    .    .    .    .WINDSONGS BRIARY BRIMSTONE,Y,F   35/1485  
.    .    .    .    .WINDSONGS MORNING MIST, ,F   35/1485  
.    .    .KUPROS MY LADY,B,F   40/94    
.    .    .    .KUPROS LADYS PRIDE, ,F   73/74    
.    .    .    .    .KUPROS BRIDGET, ,F   17/216   
.    .    .    .KUPROS LIVE SPARK,B,M   73/74    
.    .    .    .    .ALLEGHENYS BRAMBLE, ,F   72/1415  
.    .    .    .    .ALLEGHENYS MCDUFF,B,F   72/201   
.    .    .    .    .ALLEGHENYS MCTAVISH, ,F   72/201   
.    .    .    .    .CHILBROOK BRIGADIER DYNAMO,B,F   72/77    
.    .    .    .    .LABWELLS RATHAMILL RAVEN,B,F   72/1415  
.    .BARONOR PHOENIX, ,M   52/1765  
.    .    .ATTIKONAK HES SOMEBODYS EVERYTHING,Y,M   535/1818  
.    .    .HIRSIPIRTIN AMANDA,Y,F   535/534   
.    .    .    .HIRSIPIRTIN EMMA,B,F   500/533   
.    .    .    .    .HIRSIPIRTIN Q-MAKOIRA,Y,F   540/484   
.    .    .    .    .HIRSIPIRTIN XANTIPPA,B,F   522/484   
.    .    .LICITHAS BIANCO,Y,M   535/1616  
.    .    .    .LUNDSIDENS ALEX, ,M   1822/3510  
.    .    .    .    .FIELDVALLEYS FABIANCO, ,F   3363/3364  
.    .    .    .SURPRISINGS RHUFUS,Y,M   1822/1823  
.    .    .    .    .ATTIKONAK SILKY STOCKINGS,Y,F   1820/1821  
.    .    .LICITHAS BLIZZARD,Y,M   535/1616  
.    .    .    .ADITIS BECKY OF FOXRUSH, ,F   540/1904  
.    .    .    .    .FOXRUSH ALMOND OF ROCHEBY, ,F   1390/1902  
.    .    .    .    .FOXRUSH LICITHAS ANGEL, ,F   1390/1902  
.    .    .    .HIRSIPIRTIN Q-MAKOIRA,Y,M   540/484   
.    .    .    .    .MELLOWS BLONDE MAGIC,Y,F   1760/1761  
.    .    .    .LICITHAS FAITHFUL APPORTER,Y,M   540/539   
.    .    .    .    .MALLARDS CLAY BASKER,B,F   531/532   
.    .    .    .MALLARDS CADDIS WORM,B,F   540/1475  
.    .    .    .    .FAGELANGENS HAWKER HUNTER,Y,F   1773/1774  
.    .    .    .MELLOWS JONQUIL,B,F   540/1775  
.    .    .    .    .MELLOWS RINGMASTER,Y,F   1771/1772  
.    .    .    .SURPRISINGS TIMOTHY, ,M   540/1823  
.    .    .    .    .LICITHAS BACCHUS, ,F   3508/3509  
.    .    .WINNIES KLICHE, ,F   535/2857  
.    .    .    .WINNIES KAME, ,F   2853/2854  
.    .    .    .    .WINNIES BYLINE, ,F   693/2851  
.    .BRADKING BONNIE MY GIRL,Y,F   52/120   
.    .    .BRADKING BLACK CHARM,B,F   40/89    
.    .    .    .BRADKING CASSANDRA,B,F   86/87    
.    .    .    .    .BRADKING BEVERLY,C,F   342/343   
.    .    .    .    .BRADKING BRIDGETTE OF DAVRICARD, ,F   342/343   
.    .    .    .    .LILLIMARS MOONBEAM,B,F   342/343   
.    .    .    .BRADKING CASSIDY,Y,M   86/87    
.    .    .    .    .BALRION LADY OF FASHION, ,F   82/418   
.    .    .    .    .BALRION LADY OF LEASURE,Y,F   82/418   
.    .    .    .    .BALRION MAN OF THE MOMENT, ,F   82/418   
.    .    .    .    .BRADKING RANGEWAYS MR. CHIPS,Y,F   82/83    
.    .    .    .    .CAPTAIN KIRK OF RANGEWAYS, ,F   82/3220  
.    .    .    .    .HEATHERBOURNE COURT JESTER, ,F   82/1384  
.    .    .    .    .KEYSUN RIPPLING WIND, ,F   82/3022  
.    .    .    .    .KEYSUN RULING STAR OF BRADKING, ,F   82/1387  
.    .    .    .SHADOWVALES CHARM N'PRIDE, ,F   91/87    
.    .    .    .    .SHADOWVALES GYPSY SERENADE, ,F   1411/1587  
.    .    .    .SHADOWVALES FROSTY KNIGHT,Y,M   91/87    
.    .    .    .    .CHOCORUAS SEABREEZE,Y,F   84/85    
.    .    .    .    .INSELHEIMS SAVANNAH, ,F   84/747   
.    .    .    .SHADOWVALES PRINCE CHARMING, ,M   511/87    
.    .    .    .    .MUSKELUNGES BLACK CHARMER,B,F   2387/2388  
.    .    .BRADKING BONNIES CHARM OF KEYSUN, ,F   40/89    
.    .    .    .BLACKFRIARS BYZANCE, ,F   409/481   
.    .    .    .    .BLACKFRIARS BON JOVI AR CARAHILL, ,F   480/3639  
.    .    .    .KEYSUN KEKA, ,F   1391/481   
.    .    .    .    .KEYSUN RULING STAR OF BRADKING, ,F   82/1387  
.    .    .    .KEYSUN KRISPIN OF BLONDELLA, ,M   112/481   
.    .    .    .    .BLACKFRIARS BON JOVI AR CARAHILL, ,F   480/3639  
.    .    .    .    .BLONDELLA BALALAIKA, ,F   480/1889  
.    .    .    .    .BLONDELLA BALANCE, ,F   480/1889  
.    .    .    .    .BLONDELLA BEAU RANGER,Y,F   480/843   
.    .    .    .    .KAMPSALL KOMPO, ,F   480/1956  
.    .    .    .    .LEJIE LUCY, ,F   480/759   
.    .    .    .    .MERRYMILLS SEA-COMMANDER OF FOLLYTOWER, ,F   480/482   
.    .    .    .    .ROCHEBY POLISHED OAK, ,F   480/861   
.    .    .BRADKING GRACIOUS GIRL OF RANGWAYS,Y,F   88/89    
.    .    .    .BRADKING RANGEWAYS MR. CHIPS,Y,M   82/83    
.    .    .    .    .CHABLAIS CROUSTILLE,B,F   79/1687  
.    .    .    .    .CHABLAIS RIGODON,B,F   79/1687  
.    .    .    .    .CHOCORUA ON DECK AT BELQUEST,Y,F   79/80    
.    .    .    .    .CHOCORUA SEAWORTHY OF BELQUEST,Y,F   79/80    
.    .    .    .    .CROFTSPA CHINATEA, ,F   79/703   
.    .    .    .    .HILLTOP COUNTRYSIDE BARN BURNER,C,F   79/3319  
.    .    .    .    .RANBOURNE THIS BUDS FOR YOU,B,F   79/1489  
.    .    .    .    .SHADOWVALE MINSTRAL BLACK VELVET, ,F   79/739   
.    .    .FOLLYTOWER BRADKING LADY JANE,Y,F   40/89    
.    .    .    .FOLLYTOWER JENNY,B,F   1411/28    
.    .    .    .    .HARBORTOPS AUGUST KNIGHT,B,F   4/1422  
.    .    .    .KILLINGWORTHS LADY CAROLINE,Y,F   27/28    
.    .    .    .    .SNOWDEN HILLS HONEY BEAR,Y,F   9/12    
.    .    .    .    .SNOWDEN HILLS PICADILLY LILY,Y,F   9/12    
.    .    .    .    .SNOWDEN HILLS TOP NOTCH,Y,F   9/12    
.    .BRONZEDALE BRIGAND OF FRANT, ,M   52/2499  
.    .    .SUMMER SUN II,Y,M   2497/2498  
.    .    .    .JAIME OF WOODBROOK, ,F   202/203   
.    .    .    .    .AMBLESIDE MARASCHINO,Y,F   164/165   
.    .BRYNDAFYDD ATLAS, ,M   52/18    
.    .    .BRYNDAFYDD KLIO, ,F   2021/3170  
.    .    .    .BRYNDAFYDD KERIDWEN, ,F   3158/3169  
.    .    .    .    .BRYNDAFYDD ELENTARI OF BALRION,B,F   3162/3168  
.    .    .DOLAFON BLONDIE, ,F   2021/2022  
.    .    .    .DOLAFON DILS DELIGHT, ,F   205/2020  
.    .    .    .    .MERRY MADRIGAL FROM BALRION,Y,F   296/2019  
.    .CHARWAY SIMONA,B,F   52/212   
.    .    .CHARWAY BALLYWILLWILL,B,M   207/208   
.    .    .    .BARNABY OF CHARWAY,B,M   205/844   
.    .    .    .    .BEECHCROFTS MEADOWSONG,B,F   1423/552   
.    .    .    .    .KELLEYGREENS KANDYMAN,C,F   1423/2017  
.    .    .    .BLONDELLA BALLERINA, ,F   205/844   
.    .    .    .    .BLONDELLA BALALAIKA, ,F   480/1889  
.    .    .    .    .BLONDELLA BALANCE, ,F   480/1889  
.    .    .    .BLONDELLA BALLERITA, ,F   205/844   
.    .    .    .    .LUBBERLINE TOPSAIL, ,F   3638/3642  
.    .    .    .BLONDELLA BALLYWHO,B,M   205/844   
.    .    .    .    .BALRION BACK FROM THE BRINK, ,F   3304/3160  
.    .    .    .CHARWAY UNCLE TOM, ,M   205/3688  
.    .    .    .    .CAMBREMER TOM COBBLEY OF CHARWAY, ,F   3687/1937  
.    .    .    .CRAWCROOK CAMILLA, ,F   205/1886  
.    .    .    .    .CRAWCROOK SWEET CORN, ,F   1882/1883  
.    .    .    .DOLAFON DILS DELIGHT, ,F   205/2020  
.    .    .    .    .MERRY MADRIGAL FROM BALRION,Y,F   296/2019  
.    .    .    .FABRACKEN DANCING SHADOW, ,F   205/334   
.    .    .    .FABRACKEN DAYDREAMER, ,F   205/334   
.    .    .    .    .CHAFERN COURT STAR OF FABRACKEN, ,F   9/698   
.    .    .    .FOLLYTOWER WIDGEN OF BALLYDUFF, ,F   205/218   
.    .    .    .    .BALLYDUFF KALI,B,F   73/1660  
.    .    .    .FOLLYTOWER WILLOW, ,F   205/218   
.    .    .    .    .FOLLYTOWER LEWIS, ,F   2188/477   
.    .    .    .    .FOLLYTOWER MAN O'WAR, ,F   476/477   
.    .    .    .LAWNWOODS BABBLING BROOK,B,M   205/3237  
.    .    .    .    .HENNINGS MILL RAMBLIN COMIC,C,F   2416/341   
.    .    .    .    .HENNINGS MILLWILL COPPERTONE,C,F   2416/341   
.    .    .    .LINDALL BIT OF CLASS,B,F   205/396   
.    .    .    .    .LINDALL A BIT OF THE ACTION,B,F   3526/395   
.    .    .    .    .LINDALL CHARMED AT ROCHEBY, ,F   295/395   
.    .    .    .    .LINDALL CHASE,B,F   295/395   
.    .    .    .LINDALL BRIOCHE, ,F   205/206   
.    .    .    .    .BROOKLANDS HAMPSHIRE BUCKY,B,F   419/720   
.    .    .    .    .LINDALL HANNAH BROWN,C,F   3072/720   
.    .    .    .    .LINDALL LOVE IS, ,F   397/720   
.    .    .    .LINDALL MASTER RACE AT ROCHEBY,B,M   205/396   
.    .    .    .    .FOXRUSH MISCHIEF AROUND WATERMERE, ,F   1870/1871  
.    .    .    .    .RAVONE SWEET GEORGIA BROWN, ,F   1870/3333  
.    .    .    .    .ROCHEBY CHINA DOLL, ,F   1870/854   
.    .    .    .    .ROCHEBY JOSEPHS COAT,C,F   1870/2003  
.    .    .    .LINDALL MASTERCRAFT,B,M   205/206   
.    .    .    .    .BOOTHGATES MASCOT, ,F   204/3718  
.    .    .    .    .BRIAGHADW CRAFTSMAN OF ROCHEBY,B,F   204/2006  
.    .    .    .    .CHARWAY JOHN BROWN,C,F   204/248   
.    .    .    .    .EASY ACRES SABLE, ,F   204/2902  
.    .    .    .    .FOLLYTOWER BROWNTHORN, ,F   204/215   
.    .    .    .    .FOLLYTOWER MASTER BROWN OF CHARWAY,C,F   204/218   
.    .    .    .    .HUNT CLUB CHOCOLATE ECLAIRE,C,F   204/3518  
.    .    .    .    .KILLINGWORTHS DREAMER,B,F   204/2494  
.    .    .    .    .KUPROS MAJOR AT LINDALL,B,F   204/215   
.    .    .    .    .KUPROS MARSHALL,B,F   204/215   
.    .    .    .    .KUPROS MASTER MARINER,B,F   204/215   
.    .    .    .    .KUPROS MIDNIGHT FROLIC, ,F   204/215   
.    .    .    .    .PLANTIERS RUTHLESS RUTHIE,C,F   204/3486  
.    .    .    .    .RANGEWAYS MIDNIGHT LADY, ,F   204/3221  
.    .    .    .    .RAVON GIRL FRIDAY, ,F   204/470   
.    .    .    .    .SCRIMSHAW DUCKLESS FAIRBANKS,B,F   204/1916  
.    .    .    .    .SCRIMSHAW SAVING GRACE, ,F   204/1916  
.    .    .    .    .SCRIMSHAW THE HOUSE RECTOR,B,F   204/1916  
.    .    .    .    .SHADES OF BLONDELLA, ,F   204/844   
.    .    .    .    .SHAKESPEARE BALZAC DES SAVANES, ,F   204/738   
.    .    .    .    .SHAKESPEARE MISLYN DE CHABLAIS,C,F   204/738   
.    .    .    .    .TABATHAS SCRUMPTIOUS,B,F   204/1080  
.    .    .    .    .TABATHAS SIREN,B,F   204/1080  
.    .    .    .    .TABATHAS TOKEN,C,F   204/1081  
.    .    .    .LINDALL MISS EMMA,B,F   205/206   
.    .    .    .    .AMBLESIDES BANNER OF TRIPLE L,C,F   1276/2203  
.    .    .    .    .LINDALL MARCUS AT DONALBAIN, ,F   3217/2203  
.    .    .    .LINDALL MISS HOLLY,B,F   205/206   
.    .    .    .    .HENNINGS MILL CARUSO,B,F   696/759   
.    .    .    .    .HUNT CLUB HENNINGS MILL GINO,Y,F   757/759   
.    .    .    .    .LEJIE LUCY, ,F   480/759   
.    .    .    .POOLSTEAD POSITIVE MYSTERY, ,F   205/1668  
.    .    .    .    .POOLSTEAD PIPE MAJOR AT MARTINSTIDE, ,F   1082/1666  
.    .    .    .    .POOLSTEAD PIPE SMOKER,B,F   1082/1666  
.    .    .    .    .POOLSTEAD POLICE DRIVER, ,F   1892/1666  
.    .    .    .    .POOLSTEAD POP SOCKS,Y,F   1824/1666  
.    .    .    .ROCHEBY CHALICE, ,F   205/1865  
.    .    .    .    .ROCHEBY SHADY LADY, ,F   691/1864  
.    .    .    .TIMSPRING CLEVERLY, ,M   205/1430  
.    .    .    .    .CHARWAY CHARITY, ,F   1429/248   
.    .    .    .    .CHARWAY CROFTER,Y,F   1429/248   
.    .    .    .WARRINGAH HARLECH, ,M   205/3206  
.    .    .    .    .BOOTHGATES HEADLINER, ,F   3182/2557  
.    .    .    .    .BOOTHGATES HEARD THE NEWS ABOUT DONALBAIN, ,F   3182/2557  
.    .    .    .    .BOOTHGATES HOT SCOOP FOR BRANDHAMS, ,F   3182/2557  
.    .    .    .    .KENKEW DEELEY OF WARRINGAH, ,F   3182/3709  
.    .    .CHARWAY BLACKTHORN OF FOLLYTOWER,B,M   40/208   
.    .    .    .CAMBREMER BIANCA,B,F   316/1938  
.    .    .    .    .FIELDVALLEYS ALINA MERTOUN, ,F   3511/2547  
.    .    .    .CAMBREMER MADONNA, ,F   316/1938  
.    .    .    .    .CAMBREMER BE GENEROUS,B,F   295/1713  
.    .    .    .DAVRICARD BROWNED OFF, ,F   316/1869  
.    .    .    .    .DAVRICARD BOBBY SHAFTO,B,F   409/1868  
.    .    .    .FOLLYTOWER BLACKBERRY,B,F   316/1449  
.    .    .    .    .SALTMEADOW BLACKWATCH,B,F   155/1448  
.    .    .    .ROCHEBY BLACKSMITH OF ELVELEGE,B,M   316/1077  
.    .    .    .    .TABATHAS INSPIRATION,B,F   1076/1080  
.    .    .    .SIMANDEM SORCERESS OF BRENTCALM, ,F   316/317   
.    .    .    .    .BRENTCALM MISS FAWKS, ,F   2111/2112  
.    .    .    .SIMANDEN SAM BROWN AT BALRION,C,M   316/317   
.    .    .    .    .SIMANDEM OCEAN CALM, ,F   315/318   
.    .    .CHARWAY MATTIE BROWN, ,M   342/208   
.    .    .    .LINDALL MARCUS AT DONALBAIN, ,M   3217/2203  
.    .    .    .    .BRANDHAMS HOT CHOICE FOR OULSMI, ,F   2606/3716  
.    .    .    .    .DONALBAIN JOURNALIST,C,F   2606/2607  
.    .    .    .    .DONALBAIN MARKSMAN,C,F   2606/3173  
.    .    .    .    .DONALBAIN PRIVATE DANCER, ,F   2606/3173  
.    .    .    .    .DONALBAIN THE BEST,C,F   2606/3173  
.    .    .CHARWAY SALLY BROWN,C,F   40/208   
.    .    .    .CHARWAY CHARITY, ,F   1429/248   
.    .    .    .    .KELLEYGREENS KANDYMAN,C,F   1423/2017  
.    .    .    .CHARWAY CROFTER,Y,M   1429/248   
.    .    .    .    .CHILBROOK COUNRTY SQUIRE,Y,F   1427/1927  
.    .    .    .    .KELLEYGREEN HEADING WEST,Y,F   1427/1428  
.    .    .    .    .KELLEYGREENS ON TARGET,Y,F   1427/1428  
.    .    .    .    .TULIPWOOD GO ON GREEN,Y,F   1427/2122  
.    .    .    .CHARWAY JOHN BROWN,C,M   204/248   
.    .    .    .    .HENNINGS MILL MASTER BLEND,C,F   247/341   
.    .    .    .    .HENNINGS MILLS BROWN KING,C,F   247/341   
.    .    .    .    .HENNINGS MILLS MASTER BLEND,C,F   247/341   
.    .    .    .    .SUNDAZE SARAH,C,F   247/2918  
.    .    .    .    .WINGMASTERS L-TEN-ELEVEN,C,F   247/2445  
.    .    .    .CHARWAY MAVERICK,B,M   409/248   
.    .    .    .    .KELLEYGREENS MAX,Y,F   841/2477  
.    .    .    .    .WISCOYS COURT N'SPARK, ,F   841/3079  
.    .    .CHARWAY SEASHELL, ,F   342/208   
.    .    .    .ABBEYSHEAD HERON COURT,B,M   324/325   
.    .    .    .    .MAJESTIC SAXON,B,F   2848/323   
.    .    .    .    .NOVACROFT HINY CAKE, ,F   2848/2845  
.    .FRIARSGARTH MISS MUFFET OF BALRION, ,F   52/1875  
.    .    .BALRION MISS DEMEANOR, ,F   91/314   
.    .    .    .SIMANDEM SORCERESS OF BRENTCALM, ,F   316/317   
.    .    .    .    .BRENTCALM MISS FAWKS, ,F   2111/2112  
.    .    .    .SIMANDEN SAM BROWN AT BALRION,C,M   316/317   
.    .    .    .    .SIMANDEM OCEAN CALM, ,F   315/318   
.    .    .BALRION STAR QUEST, ,F   313/314   
.    .    .    .BALRION KINGS KNIGHT, ,M   91/150   
.    .    .    .    .TABATHAS CLAMOR, ,F   2178/436   
.    .    .    .    .TABATHAS DASH, ,F   2178/436   
.    .    .    .BALRION KINGS RANSOM, ,M   91/150   
.    .    .    .    .LADY BOUNTIFUL AT BALRION, ,F   296/1703  
.    .    .    .    .LINDALL RACHELLE, ,F   296/467   
.    .    .    .    .LYMELLYN LOOSE LIVING AT BALRION, ,F   296/2422  
.    .    .    .    .MERRY MADRIGAL FROM BALRION,Y,F   296/2019  
.    .    .    .    .SIMANDEM KINGS NEPTUNE,B,F   296/297   
.    .    .    .    .SIMANDEM STORM FORCE FROM BALRION, ,F   296/297   
.    .    .    .    .SPINNEY BROOK LAUREL, ,F   296/3028  
.    .    .    .BALRION STAR ATTRACTION,B,F   91/150   
.    .    .    .    .KELLEYGREENS BLK DYNAMO,B,F   30/31    
.    .GAIRLOCHS BLACK BRITANIA,B,F   52/942   
.    .    .CHILBROOK SEA RAVEN,B,M   55/945   
.    .GROUCHO OF MANSERGH,B,M   52/1392  
.    .    .ELLERTHWAITE JAY, ,F   241/242   
.    .    .    .ALLEGHENY BEZIQUE,B,F   52/240   
.    .    .    .    .ALLEGHENYS BABY BUNTING, ,F   220/201   
.    .    .    .    .ALLEGHENYS ECLIPSE,B,F   220/201   
.    .    .    .    .ALLEGHENYS MCDUFF,B,F   72/201   
.    .    .    .    .ALLEGHENYS MCTAVISH, ,F   72/201   
.    .    .    .    .ALLEGHENYS TWILIGHT, ,F   220/201   
.    .    .GRANDE DAME OF MANSERGH,B,F   241/2377  
.    .    .    .BORADORS CAPTAIN NEMO,B,M   2575/2374  
.    .    .    .    .ASHWAYS ANGUS,B,F   2571/2572  
.    .    .    .BORADORS DAME FORTUNE,B,F   219/2374  
.    .    .    .    .BORADORS NOT BAD FOR BROWN,C,F   2380/2379  
.    .    .    .SANDALWOOD TAPESTRY,B,F   1276/2374  
.    .    .    .    .WILLCARES MASTERPIECE,C,F   2372/2373  
.    .    .MANSERGE OLD GEEZER,B,M   241/1096  
.    .    .    .APPYLANDS WATERBOUND IKE,B,M   1095/1785  
.    .    .    .    .APPYLANDS KALI SUE,B,F   1784/2532  
.    .    .    .    .WATERBOUND BLACKSTONE SHEA,B,F   1784/1800  
.    .    .    .    .WATERBOUND FLYING SCOTSMAN,Y,F   1784/1787  
.    .    .    .MIJANS TOO HOT TO HANDLE, ,F   1095/1093  
.    .    .    .    .MIJANS SOME LIKE IT HOT,B,F   1090/1091  
.    .    .MANSERGH MERRY GENTLEMAN, ,M   241/1519  
.    .    .    .MANSERGH OOH-LA-LA,B,F   1791/1793  
.    .    .    .    .MANSERGE OLD GEEZER,B,F   241/1096  
.    .HEATHERBOURNE MOIRA,B,F   52/602   
.    .    .HEATHERBOURNE FORGET ME NOT,B,F   91/347   
.    .    .    .SHADOWVALE JUST SO, ,F   344/346   
.    .    .    .    .TWEEDCROFTS DEBONAIR, ,F   1090/1897  
.    .    .    .    .TWEEDCROFTS REFLEXION, ,F   9/1897  
.    .    .    .SHADOWVALES JILL AT RAMBOURNE,B,F   344/346   
.    .    .    .    .RANBOURNE THIS BUDS FOR YOU,B,F   79/1489  
.    .    .    .SHADOWVALES JUST A LOVE SONG, ,F   344/346   
.    .    .    .    .CIRQUES CURTAIN CALL, ,F   155/1971  
.    .    .    .SHADOWVALES JUST REWARD,Y,M   344/346   
.    .    .    .    .BEAUTAWNS IMPORTER,Y,F   353/349   
.    .    .    .    .BEAUTAWNS INSIDE INFORMATION,Y,F   353/349   
.    .    .    .SHADOWVALES STATESMAN,B,M   1411/346   
.    .    .HEATHERBOURNE STATESMAN, ,M   40/347   
.    .    .    .ROSEACRE STATE SECRET, ,F   1614/1596  
.    .    .    .    .SENDERBRAYKE ALACRITY,B,F   1779/1776  
.    .JAYNCOURT LUCKY CHARMER, ,F   52/614   
.    .    .JAYNCOURT STAR ATTRACTION, ,F   156/615   
.    .    .    .JAYNCOURT STAR SHADOW, ,F   234/616   
.    .    .    .    .JAYNCOURT AJOCO FOREVER,B,F   153/2024  
.    .    .JAYNCOURT STAR-MISTY, ,F   156/615   
.    .    .    .JAYNCOURT STAR PERFORMER,Y,F   88/593   
.    .    .    .    .JAYNCOURT AJOCO JUSTICE,B,F   17/345   
.    .    .    .JAYNCOURT STAR-APPEAL,Y,F   88/593   
.    .    .    .    .JAYNCOURT DANCING STAR, ,F   153/617   
.    .    .    .    .JAYNCOURT STAR-QUALITY, ,F   153/617   
.    .    .    .NOVACROFT JAYNCOURT TRULY FAIR, ,F   63/593   
.    .KAMRATS BUSE,B,M   52/529   
.    .    .MELLOWS KASSANDRA,B,F   527/1778  
.    .    .    .MELLOWS ELVIRA,B,F   1380/1777  
.    .    .    .    .MELLOWS JONQUIL,B,F   540/1775  
.    .    .SUSANSET ILLUUSIA,B,F   527/528   
.    .    .    .ROSANAN DANDELION,B,M   520/521   
.    .    .    .    .CAVERIS KAN-NIBAL,B,F   518/519   
.    .KEITHRAY MARIANNE,B,F   52/1531  
.    .    .PUHS INDRA,B,M   156/1532  
.    .    .    .SURPRISINGS NORAH,Y,F   1830/1827  
.    .    .    .    .SURPRISINGS RHUFUS,Y,F   1822/1823  
.    .    .    .    .SURPRISINGS TIMOTHY, ,F   540/1823  
.    .    .PUHS SUPERMAN,C,M   567/1532  
.    .    .    .BALNAMORES CHIKARA,B,F   511/2876  
.    .    .    .    .BALNAMORES BONANZA,B,F   1978/2868  
.    .    .    .MARSHVIEW SUNNYBROOK NUTMEG, ,F   511/512   
.    .    .    .    .SUNNYBROOK ACRES BLACK STAR,B,F   6/510   
.    .    .    .PUHS SEA CORAL,C,F   511/2048  
.    .    .    .    .HAMPSHIRES SECRET,C,F   2035/2047  
.    .    .    .SHADOWVALES PRINCE CHARMING, ,M   511/87    
.    .    .    .    .MUSKELUNGES BLACK CHARMER,B,F   2387/2388  
.    .    .    .STERLINGS MUD PIE SAL,C,F   511/2443  
.    .    .    .    .JANRODS APPLE BUTTER,C,F   2035/2442  
.    .    .    .SUNNYBROOK ACRES DENALI DIZ, ,F   511/1526  
.    .    .    .    .ALIHO DENALI COALER,B,F   686/597   
.    .    .    .    .ALIHOS CASEY OF LAKE CREEK, ,F   686/597   
.    .KEYSUN TEKO OF BLONDELLA,B,M   52/471   
.    .    .BLONDELLA SAM-SON, ,M   112/847   
.    .    .    .BLONDELLA MOLLYWOG,B,F   845/846   
.    .    .    .    .BARNABY OF CHARWAY,B,F   205/844   
.    .    .    .    .BLONDELLA BALLERINA, ,F   205/844   
.    .    .    .    .BLONDELLA BALLERITA, ,F   205/844   
.    .    .    .    .BLONDELLA BALLYWHO,B,F   205/844   
.    .    .    .    .SHADES OF BLONDELLA, ,F   204/844   
.    .    .KEYSUN KRISPIN OF BLONDELLA, ,M   112/481   
.    .    .    .BLACKFRIARS BON JOVI AR CARAHILL, ,M   480/3639  
.    .    .    .    .LUBBERLINE TOPSAIL, ,F   3638/3642  
.    .    .    .BLONDELLA BALALAIKA, ,F   480/1889  
.    .    .    .    .BLONDELLA BARLEYCORN OF MARLOVA, ,F   851/1885  
.    .    .    .BLONDELLA BALANCE, ,M   480/1889  
.    .    .    .    .BLONDELLA BALANACED SHADES, ,F   2111/843   
.    .    .    .    .BRENTCALM MISS FAWKS, ,F   2111/2112  
.    .    .    .    .LOUGIN LANCER,B,F   2111/3723  
.    .    .    .BLONDELLA BEAU RANGER,Y,M   480/843   
.    .    .    .    .WISCOYS SKYES T'LIMIT, ,F   842/3078  
.    .    .    .    .ZANE HILLS SUGAR CAIN,Y,F   842/3573  
.    .    .    .KAMPSALL KOMPO, ,M   480/1956  
.    .    .    .    .SWEETTREES PATRIOT,B,F   1954/1955  
.    .    .    .LEJIE LUCY, ,F   480/759   
.    .    .    .    .EXHIBITION MAN DE SAINT URBAIN,C,F   2027/2031  
.    .    .    .MERRYMILLS SEA-COMMANDER OF FOLLYTOWER, ,M   480/482   
.    .    .    .    .FOLLYTOWER MAN O'WAR, ,F   476/477   
.    .    .    .ROCHEBY POLISHED OAK, ,F   480/861   
.    .    .    .    .ROCHEBY ACORN,Y,F   853/854   
.    .    .    .    .ROCHEBY CHINA DOLL, ,F   1870/854   
.    .    .    .    .ROCHEBY YORKSHIREMAN,B,F   691/854   
.    .    .NEWINN KESTREL,Y,M   112/113   
.    .    .    .BONFIELD LADY,Y,F   104/1755  
.    .    .    .    .RANSOM OF SANDYLANDS,Y,F   151/421   
.    .    .    .KUPROS KIRSH, ,F   104/94    
.    .    .    .    .KUPROS SPARTACUS,B,F   73/1402  
.    .    .    .    .KUPROS SPRING FOLLY OF WETHERLAM, ,F   73/1402  
.    .    .    .    .KUPROS STARSHINE,B,F   73/1402  
.    .    .    .NEWINN NATTERJACK, ,M   104/1084  
.    .    .    .    .KEYSUN KEKA, ,F   1391/481   
.    .    .    .POLLYS PRIDE OF GENISVAL,Y,F   104/105   
.    .    .    .    .RECEIVER OF CRANSPIRE,Y,F   25/26    
.    .    .PASSINGRIDGE BLACK PRINCE,B,M   112/1403  
.    .    .    .BEECHCROFTS DANISH CHEER,B,M   722/552   
.    .    .    .    .WINTERSET JOS SECRET ADMIRER, ,F   2113/3482  
.    .    .    .BEECHCROFTS DANISH SKYDIVER,B,M   722/723   
.    .    .    .    .BEECHCROFTS PERFECTA, ,F   2386/729   
.    .    .    .    .BEECHCROFTS REGAL AIR,B,F   2386/729   
.    .    .    .HIGHTIDES CANADIAN RUST, ,M   722/723   
.    .    .    .    .BEECHCROFT ANTICIPATION, ,F   717/729   
.    .    .    .    .BEECHCROFT CRICKETEER,B,F   717/1831  
.    .    .    .    .BEECHCROFT SHADOWGLEN JOY, ,F   717/1580  
.    .    .    .    .SHADOWGLEN BLACKWATCH GHILE,B,F   717/1580  
.    .    .    .    .TWEEDLEDUM MIDNIGHT SUN, ,F   717/721   
.    .    .RAVONE YORKSHIRE LADY OF ROCHEBY, ,F   112/472   
.    .    .    .RAVON GIRL FRIDAY, ,F   204/470   
.    .    .    .    .LINDALL PERSONALITY,Y,F   1819/467   
.    .    .    .    .LINDALL RACHELLE, ,F   296/467   
.    .KIMVALLEY PICKLEWITCH,B,F   52/953   
.    .    .SPRINGFIELDS PICCADILLY,B,F   961/952   
.    .MANSERGH ANTONIA, ,F   52/1519  
.    .    .MANSERGH MANTUAN,B,M   1523/1520  
.    .    .    .FLAXENFIELDS JULIA OF BLYN, ,F   1265/964   
.    .    .    .    .BLACKTHORN FLAXENFIELD RUBY, ,F   636/637   
.    .    .    .    .FLAXENFIELD CALCUTTA KATIE, ,F   636/637   
.    .MINIVET OF SUDDIE, ,F   52/1325  
.    .    .SAM OF SUDDIE,Y,M   927/1638  
.    .    .    .SANDYLANDS SOLACE AT LINERSHWOOD, ,F   865/866   
.    .    .    .    .DICKENDALLS SO FINE,Y,F   460/1604  
.    .    .    .    .LINERSHWOOD STICKY WICKET,Y,F   234/1604  
.    .    .    .    .LINERSHWOOD STORM WARNING,B,F   234/1604  
.    .    .    .SANDYLANDS SOVEREIGN OF SUDDIE,Y,M   865/866   
.    .    .    .    .CARPENNY CAMARGUE, ,F   857/858   
.    .    .    .    .CARPENNY CARMARGUE, ,F   857/858   
.    .    .    .    .FOLLYTOWER SABER,B,F   857/1451  
.    .    .    .    .FOLLYTOWER SHORTBREAD, ,F   857/1451  
.    .    .    .    .FOLLYTOWER SIR KEN, ,F   857/218   
.    .    .    .SANDYLANDS SPARKLE, ,F   865/866   
.    .    .    .    .SANDYLANDS RADIANCE,F,F   151/407   
.    .    .    .    .SANDYLANDS ROSY,Y,F   151/407   
.    .    .    .    .SANDYLANDS ROYAL ENVOY, ,F   151/407   
.    .NEWINN HARMONY OF PERDON, ,F   52/600   
.    .    .PERADON SALUTE TO LINERSHWOOD, ,M   1473/1474  
.    .    .    .HARBORTOP SALUTE TO RAMLIN,B,M   1471/1472  
.    .NOKEENER MAY BLOSSOM OF LASGARN, ,F   52/0     
.    .NUTGROVE DOUBLET,B,M   52/3083  
.    .    .MORNINGTOWN TOBLAR,C,F   213/214   
.    .    .    .MORNINGTOWN STORMETTE,C,F   40/209   
.    .    .    .    .LINDALL BRIOCHE, ,F   205/206   
.    .    .    .    .LINDALL CLASSIC,C,F   397/206   
.    .    .    .    .LINDALL MASTERCRAFT,B,F   205/206   
.    .    .    .    .LINDALL MISS EMMA,B,F   205/206   
.    .    .    .    .LINDALL MISS HOLLY,B,F   205/206   
.    .    .    .    .LINDALL MOLLIE MALONE, ,F   342/206   
.    .POOLSTEAD PIN UP OF FABRACKEN, ,F   52/1468  
.    .    .FABRACKEN COMEDY STAR,B,M   333/334   
.    .    .    .BRADKING BEVERLY,C,F   342/343   
.    .    .    .    .HENNINGS MILL CALYPSO BEAUTY,C,F   339/341   
.    .    .    .    .HENNINGS MILL CHARMING BEAUTY,B,F   338/341   
.    .    .    .    .HENNINGS MILL MASTER BLEND,C,F   247/341   
.    .    .    .    .HENNINGS MILL RAMBLIN COMIC,C,F   2416/341   
.    .    .    .    .HENNINGS MILLS BROWN KING,C,F   247/341   
.    .    .    .    .HENNINGS MILLS COURT BEAUTY, ,F   696/341   
.    .    .    .    .HENNINGS MILLS MASTER BLEND,C,F   247/341   
.    .    .    .    .HENNINGS MILLWILL COPPERTONE,C,F   2416/341   
.    .    .    .BRADKING BRIDGETTE OF DAVRICARD, ,F   342/343   
.    .    .    .CAMBREMER MONTCLAIR, ,F   342/1903  
.    .    .    .    .CAMBREMER ALL THAT JAZZ, ,F   409/1938  
.    .    .    .    .CAMBREMER BIANCA,B,F   316/1938  
.    .    .    .    .CAMBREMER CLASSICAL JAZZ, ,F   409/1938  
.    .    .    .    .CAMBREMER COPY CAT, ,F   409/1938  
.    .    .    .    .CAMBREMER DU VALLON DE VILLIARD, ,F   409/1938  
.    .    .    .    .CAMBREMER JAZZ SINGER,B,F   409/1938  
.    .    .    .    .CAMBREMER MADONNA, ,F   316/1938  
.    .    .    .    .CAMBREMER STRIKING MIDNIGHT OVER LAWNWD, ,F   869/1938  
.    .    .    .CAMBREMER MR.ROSS, ,M   342/1903  
.    .    .    .    .ANBROUGH NIGHT SKY, ,F   1998/1999  
.    .    .    .    .GUIDELINES MAKE NO DOUBT, ,F   1998/1891  
.    .    .    .CHARWAY MATTIE BROWN, ,M   342/208   
.    .    .    .    .LINDALL MARCUS AT DONALBAIN, ,F   3217/2203  
.    .    .    .CHARWAY SEASHELL, ,F   342/208   
.    .    .    .    .ABBEYSHEAD HERON COURT,B,F   324/325   
.    .    .    .CRANSPIRE AYANEE,B,F   342/103   
.    .    .    .    .CRANSPIRE LACE, ,F   9/2106  
.    .    .    .HAVERTON TAWNY PIPPET AT BRIGBURN, ,F   342/3211  
.    .    .    .    .BRIGBURN ZENNY, ,F   3208/3209  
.    .    .    .LILLIMARS MOONBEAM,B,M   342/343   
.    .    .    .LINDALL MOLLIE MALONE, ,F   342/206   
.    .    .    .    .BOOTHGATES CRAZY KAPER, ,F   409/2557  
.    .    .    .    .BOOTHGATES HEADLINER, ,F   3182/2557  
.    .    .    .    .BOOTHGATES HEARD THE NEWS ABOUT DONALBAIN, ,F   3182/2557  
.    .    .    .    .BOOTHGATES HOT SCOOP FOR BRANDHAMS, ,F   3182/2557  
.    .    .    .POOLSTEAD PICK ME UP, ,F   342/1835  
.    .    .    .    .EIREANNACH COACHMASTER,B,F   220/2013  
.    .    .    .POOLSTEAD PICK OF THE POPS,B,M   342/1835  
.    .    .    .    .ALVGARDENS X PRINCESS,B,F   2435/2436  
.    .    .    .SULEYS SATAN BUG,B,M   342/1825  
.    .    .    .    .POOLSTEAD POP SOCKS,Y,F

jusahah87
10 years ago
 Best Answer

Level 5

I've done pretty much similar stuff but with categories (each category could have arbitrary many subcategories, no limit on recursion).


I did this with a recursive function and collecting stuff, pretty much same way you mentioned.
// Category.php

// Get recursively all child categories for the Category of id "categoryId".
// $categories is array of all categories application has.
public static function getAllChildCategories($categoryId, $categories) {

        // Start by getting direct children of the category.
        $directChildren = $categories->filter(function($c) use ($categoryId) {
            return $c->parent_id == $categoryId;
        });
        
        if ($directChildren->count() === 0) return []; // No child categories at all

        // Collect recursively 2nd level or deeper child categories.
        $kidKids = [];
        // Populate kidKids array recursively
        foreach ($directChildren as $key => $childCategory) {
            array_push($kidKids, $childCategory);
                // Recurse to next level
            array_push($kidKids, self::getAllChildCategories($childCategory->id, $categories));
        }

        return $kidKids;
}


This is surely not the most efficient, but if you use caching (like you mentioned), its okay.
Above method was then called like this:
// Get all descendants for category with id 4.
$allChildren = Category::getAllChildCategories(4, Category::all())->flatten();


Caching the outline tree is a good idea. I think you could it like this:

Set Eloquent model listeners for Family.
Every time a family is inserted/updated, clear cache and rerun calculations

I would not use separate JSON files here, but Laravel's built-in cache functionality.

ok4mee OP 
10 years ago

Level 1

Wow- thank you both, I'm so glad I asked! @jlrdw- cool that you have a family tree. The approach you described is what I did originally on my old asp version way back when (repeating specific calls and having record sets for a specific number of generations)- now that I'm more comfortable with recursion I want to give that a try, and even moreso I'm looking for a way to save the results somewhere and display it from laravel, so the user isn't waiting for it to run each time since it won't change very often.


@jusahah87: I'll read through the laravel cache documentation, and watch this overview here:
https://laracasts.com/lessons/caching-essentials
Thanks!!

ok4mee OP 
10 years ago

Level 1

Update- I got it working, and that was a big help!

jlrdw
10 years ago

Level 75

Could you share?

ok4mee OP 
10 years ago

Level 1

Sure! Here's my get_descendants function that I'm using (and then I needed a recursive view to display also, oy):


public static function get_descendants(Family $family, $results_array, $counter)
{
    // start new round with a different temp array, to keep track
    $counter++;
    $this_array = "array_$counter";
    $$this_array = [];

    array_push ($$this_array, [$family->caption, $family->id, 'family']);

    $kids = FamilyController::get_kids_of_family($family);

    // if family has no kids, return 0;
    if (!count($kids))
    {
        return 0;
    }

    else // add kids and check for their families
    {
        foreach ($kids as $kid) {
            array_push ($$this_array, [$kid->first . " " . $kid->last, $kid->id, 'person']);

            // get families made by kid- for each one, call get_descendants
            $families_made = FamilyController::get_families_person_made($kid);

            if (count($families_made))
            {
                foreach ($families_made as $new_family) {
                    array_push($$this_array, self::get_descendants($new_family, $$this_array, $counter));
                }
            }
        };
    }
    return $$this_array;
}

I call it from my controller, and I cache the results (and look to use them when they're there).  It turned out to be necessary since trying to pull all the families without it (and then iterate through all the results displaying the outline) timed out!  Now that it's cached it loads lickety split

willvincent
10 years ago

Level 54

Frankly this scenario strikes me as the perfect case for a preorder tree traversal.. updates are slow, but reads are VERY fast, and the data comes out of the DB (In a single query) already in the right order to display the tree.. so no recursion to assemble the tree.


See: https://www.sitepoint.com/hierarchical-data-database-2/

jlrdw
10 years ago

Level 75

The funny part is my first pedigree program was Done in dbase 3 on an old computer and the list as shown above could take up to 4 minutes but now in Microsoft Access VBA on a modern computer the whole thing happens in a blink of an eye funny what a faster processor will do. Unfortunately this stuff can still take a while with an online database. When we had ours up for a while we only did Regular pedigrees online and then only 3 generation which was fairly standard at the time. This was back during dial up days before high speed internet. @ok4mee you mentioned asp I actually started out in Java using servlets and JSP.

Please or to participate in this conversation.