Millions of records...



  • form http://blog.everythingflex.com/2007/01/24/announcing-ringdesignonlinecom-flex-2/

     

    "This application is the results of many hours of Flex development by myself as well as a large SQL server project for the millions of records of data representing the millions of possible ring combinations, and many hours of design work on the thousands of ring image assets by our talented SQL team and graphics designer."

     

    Oh dear, either this is badly worded or the "talented sql team" really fucked up the db design.... I can just picture the db, 1 table with millons of rows, 1 for each possible combination



  • Since I'm not allowed to edit my message amymore ("time limit for editing messages" wtf?) I add for those that do not want to check the link, that the app is about designing a finger ring, you know, pick a color, shape, engraving etc. 5 colors, 6 shapes, 53 letters with a max of 10 letters will already make 15900 records for the talented sql team to maintain...



  • flex? the free version of lex?

    FLEX(1)                                                                FLEX(1)
    
    NAME
           flex - fast lexical analyzer generator
    
    DESCRIPTION
           flex is a tool for generating scanners: programs which recognized lexi-
           cal  patterns  in text.  flex reads the given input files, or its stan-
           dard input if no file names are given, for a description of  a  scanner
           to  generate.   The  description  is  in  the  form of pairs of regular
           expressions and C code, called rules. flex  generates  as  output  a  C
           source  file,  lex.yy.c, which defines a routine yylex().  This file is
           compiled and linked with the -lfl library  to  produce  an  executable.
           When  the  executable  is run, it analyzes its input for occurrences of
           the regular expressions.  Whenever it finds one, it executes the corre-
           sponding C code.
    

    ... we were just using this today in the Programming Languages lab... but... the site seems to be about a different flex... :(



  • It does sound like they've stored every possible ring combination, rather than having a sensible relational structure and creating records as required. It'd be interesting to see why it takes these millions of rows?



  • @fennec said:

    flex? the free version of lex?

    ... we were just using this today in the Programming Languages lab... but... the site seems to be about a different flex... :(

    <obvious level="master">It's definitely something else. </obvious>



  • I can't get the app to work.  I picked a high school near me (they used HJ to do their rings last time I checked) and it said the data was not available.  Then I filled in my name and got this helpful error message.



  • @fly2 said:

    Since I'm not allowed to edit my message amymore ("time limit for editing messages" wtf?) I add for those that do not want to check the link, that the app is about designing a finger ring, you know, pick a color, shape, engraving etc. 5 colors, 6 shapes, 53 letters with a max of 10 letters will already make 15900 records for the talented sql team to maintain...

    Actually it would be 413400 with those numbers, if they did it that way....

     I just think it was an exaggeration of the number of records.

    It is more likely they have a table for each part of the ring. What would take the most records is the list of all the schools/cities and any unique symbols the school might have.

    Whatever the case, its a nice site. 



  • Hehe, NO, you forgot about the 174,887,470,365,513,049 possible combinations of all 10 letter positions with 53 possible characters...

    So, 53^10 * 5 colors * 6 shapes = 5,246,624,110,965,391,470 combinations.

     



  • @fennec said:

    flex? the free version of lex?

    FLEX(1)                                                                FLEX(1)

    NAME
    flex - fast lexical analyzer generator

    DESCRIPTION
    flex is a tool for generating scanners: programs which recognized lexi-
    cal patterns in text. flex reads the given input files, or its stan-
    dard input if no file names are given, for a description of a scanner
    to generate. The description is in the form of pairs of regular
    expressions and C code, called rules. flex generates as output a C
    source file, lex.yy.c, which defines a routine yylex(). This file is
    compiled and linked with the -lfl library to produce an executable.
    When the executable is run, it analyzes its input for occurrences of
    the regular expressions. Whenever it finds one, it executes the corre-
    sponding C code.

    ... we were just using this today in the Programming Languages lab... but... the site seems to be about a different flex... :(

     

    Flex, the "free" Flash development SDK: http://www.adobe.com/products/flex/
     



  • @JamesKilton said:

    Flex, the "free" Flash development SDK: http://www.adobe.com/products/flex/
     

     

    Free? Not according to that link.



  • @mattwho said:

    @JamesKilton said:

    Flex, the "free" Flash development SDK: http://www.adobe.com/products/flex/
     

     

    Free? Not according to that link.

     

    Being 'free' all depends on where you look :)



  • The site looks nice. But anybody try actually using it? Everytime you do anything it takes forever to load



  • @AustinW said:

    The site looks nice. But anybody try actually using it? Everytime you do anything it takes forever to load

     

    The site works well and has nice feel to it except the error messages suck major a$$, now if yoda read the error messages they may make more sense. 


Log in to reply