Skip to main content

Emanuel Costa

Member since Dec 11, 2008

Recent Blog Comments By Emanuel Costa

  • Building An Angular App For ColdFusion Using Docker Compose

    Posted on Aug 21, 2024 at 8:10 PM

    Thanks for sharing your approach. Given your current setup with FTP and your preference to keep the Angular build separate from the ColdFusion app, your strategy makes sense. However, if you're open to exploring alternatives, I suggest looking into using a build pipeline or CI/CD system that... read more »

  • 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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel