« previous next »
Pages: [1]

Author Topic: Sql stored procedure faster or sql views  (Read 705 times)

0 Members and 1 Guest are viewing this topic.

Offline zohabTopic starter

  • Enthusiast
  • Posts: 175
  • Gender: Male
    • View Profile
Sql stored procedure faster or sql views
« on: February 24, 2010, 12:34:51 AM »
Hi,

In my project i have use 3 sql queries join by UNION ALL to generate report using
3 tables .

I am facing some performance related issue and planing to create Sql stored procedure or sql views.

Which one will give me fast result?
Logged

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,444
  • Gender: Male
    • View Profile
Re: Sql stored procedure faster or sql views
« Reply #1 on: February 24, 2010, 02:47:55 PM »
Not all views can be generated with the MERGE algorithm.  And SPs usually slow things down.
Logged
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.
Pages: [1]
« previous next »