Emanuel Costa

Recent Blog Comments By Emanuel Costa

• I Just Can't Understand Object Oriented Programming (OOP) And Join Tables

  Posted on Aug 19, 2007 at 1:03 PM

  @Ben Correct, the performance there shouldn't be a problem, since it is one cfquery been executed. I wonder what difference could be on mysql. Will test later and let you know. @Chip On my tests when using this type of single statement (using select and union) on mssql the performance is 3x slowe... read more »

• I Just Can't Understand Object Oriented Programming (OOP) And Join Tables

  Posted on Aug 18, 2007 at 5:00 PM

  @tony I am pretty sure with you take a look at mssql documentation (books online) you will find something. @ben One thing is loop on your code to build the statement. This may take miliseconds. And another is make many statement to connect to a DB and execute the statement. That, depending on the... read more »

• I Just Can't Understand Object Oriented Programming (OOP) And Join Tables

  Posted on Aug 18, 2007 at 2:57 PM

  @toni That would depend on the DB type. For mysql could be something like: INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9); So, as you can see you don't need multiple insert statements to add multiple rows. Regards... read more »

• I Just Can't Understand Object Oriented Programming (OOP) And Join Tables

  Posted on Aug 18, 2007 at 1:54 PM

  That loop for multiple insert statements is nasty. I would rather create a query on the fly using querynew function or send this to be done on the db side using a procedure and then run only one insert statement. I believe would make a big performance difference specially if there are too many recor... read more »