Re: Help on selecting a View with 3 Billions rows !

2007-05-23 Thread Chris Prakoso
matter if the tables are using MyISAM or InnoDB ? Cheers, Chris - Original Message From: Brent Baisley <[EMAIL PROTECTED]> To: Chris Prakoso <[EMAIL PROTECTED]>; mysql@lists.mysql.com Sent: Wednesday, 23 May, 2007 1:30:50 PM Subject: Re: Help on selecting a View with 3 Billion

Help on selecting a View with 3 Billions rows !

2007-05-22 Thread Chris Prakoso
Hi all, I am having a big performance performance problem here, and I was wondering if you could give me some advise here. I have 2 big static tables, one with 65K rows, the other with 54K rows. I need to do a calculation for each combination of these two table rows. So what I did was to