RE: AW: [PHP] How to argue with ASP people...

[Max Michaels]

QUOTE
And if you believe ASP.NET only provides a few benefits, then you are
adequately informed, my friend
 
Freddie
/QUOTE

I agree completely!

Max Michaels
Systems Engineer
Right Media LLC

-Original Message-
From: Freddie Sorensen [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 31, 2004 10:02 AM
To: [EMAIL PROTECTED]
Cc: 'mail.pmpa'; mysql@lists.mysql.com
Subject: AW: AW: [PHP] How to argue with ASP people...

Shawn,
 
It is worth it for performance reasons !
 
And yes, I am LOOKING at the code and DEBUGGING it every single day, also
without the use of VS, what's the problem ?
 
And it is global.asax, not global.asp
 
I and my colleagues have never had a project which we didn't get right the
first time, I mean in terms of having to reinstall anything, it was always
very easy
 
And if you believe ASP.NET only provides a few benefits, then you are
adequately informed, my friend
 
Freddie
 

  _  

Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 31. Dezember 2004 15:26
An: Freddie Sorensen
Cc: 'mail.pmpa'; mysql@lists.mysql.com
Betreff: Re: AW: [PHP] How to argue with ASP people...



Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... )
that VS produces to make an ASP.NET application?  Have you EVER had to be in
the position to debug and modify that by hand (without the aid of VS)?  I
have.  I ask that you try it before you continue your high praise for the
product. 

I fully believe that M$ is so full of themselves for offering this as
anything approaching efficient.  It's designed in such a way that once you
convert, you will have a very hard time getting away from it because it is
SO convoluted in its execution. I feel that it's meant more to trap you into
staying with their product than making life easier.   

I have tried (or assisted others) on more than one occasion to get ASP.NET
functioning for full development support (server-side debugging, full VS
integration, yadda yadda yadda) and have YET to see anyone get it right the
first time.  Usually we have to rip out and reinstall or update and upgrade
which required us to compare and contrast several different explanations
from MSDN about what may be wrong and how to fix it.  Eventually, we made it
work but it was never easy. 

IF you like it, fine. You may use it. I however recommend against it. Stick
with PHP, ASP, PERL, or Python (whichever you prefer) but I personally don't
think that ASP.NET is worth the effort for the few benefits it provides. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

Freddie Sorensen [EMAIL PROTECTED] wrote on 12/31/2004 04:01:14 AM:

 Tony,
 
 Check out ASP.NET and you will want to forget everything about PHP ;-)
 
 Freddie 
 
  -Ursprüngliche Nachricht-
  Von: mail.pmpa [mailto:[EMAIL PROTECTED] 
  Gesendet: Freitag, 31. Dezember 2004 03:27
  An: mysql@lists.mysql.com
  Betreff: RE: [PHP] How to argue with ASP people...
  
  Don't mean to start a discussion whatsoever, I love php, but 
  one thing i can't do in php is Response.Redirect(page.asp) .
  Apart from that no complains so far :)
  
  * Happy New Year *
  
  Pedro Almeida.
  
  
  -Mensagem original-
  De: Tony Di Croce [mailto:[EMAIL PROTECTED] 
   
  I am fairly new to PHP, but I am loving it... I have recently 
  gotten involved in a business venture and I have been using 
  PHP so far...
  Recently I have taken on a partner, and he is a big ASP guy...
  
  I am not totally against ASP, but it would have to be pretty 
  good to get me to switch at this point (PHP seems to do 
  everything I need)...
  But I will need to convince him of this...
  
  What points can I bring up in PHP's favor? In what areas does 
  PHP trounce ASP?
  
  -- 
  
  td
  
  --
  PHP General Mailing List (http://www.php.net/) To 
  unsubscribe, visit: http://www.php.net/unsub.php
  
  
  
  
  
  -- 
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  http://lists.mysql.com/[EMAIL PROTECTED]
  
  
 
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

php mysql library and mysql 4.1.x

[Max Michaels]

Hello all,

I know the php manual warns that some functionality may not work if you use the 
regular mysql libraries with mysql versions greater than 4.1.x. I have found so 
far that MYSQL_ASSOC return types don't work, just wondering if anybody has 
found any other issues. I would just have the developers re-write the 
application using mysqli instead of mysql, but this is a very time sensitive 
issue. Any opinions/ideas appreciated?

Regards,

Max


Max Michaels
Right Media, LLC  |  276 5th Avenue, Suite 605  | New York , NY 10001
xxx.xxx. | [EMAIL PROTECTED] | www.rightmedia.com 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

slow query issues

[Max Michaels]

Hello all,

Recently, I have been seeing some strange behavior from a particular query on 
my 4.0.21 mysql server. Here is the query in question:

SELECT size_id, sum(imps) imps, sum(clicks) clicks, sum(convs) convs, 
sum(imp_revenue) imp_revenue, sum(click_revenue) click_revenue, 
sum(conv_revenue) conv_revenue, sum(international_imps) international_imps, 
sum(adjustments) / 60 adjs, sum(publisher_compensation) / 60 comp FROM 
publisher_summary WHERE ymdh = '2004-11-01 05:00:00' AND ymdh  '2004-12-01 
05:00:00' AND is_ym_advertiser=0 GROUP BY size_id;

There is an index on ymdh, another on both is_ym_advertiser and ymdh, and 
another on size_id. The query is using the index that is on both 
is_ym_advertiser and ymdh and is scanning 7 million rows according to explain 
select. Explain select also says that it is a query of type ref.  The table it 
is selecting from contains approximately 27 million rows.

Until a few days ago, the query would take about 2 minutes to complete. This is 
a long time, but considering how often this query is run, it was acceptable. 
Now this query is taking more than 30 minutes to return data and I have no idea 
why. I did some testing and replicated the table to my testing environment 
without the indexes. Here the query is taking the normal 2-3 minutes without 
the indexes. Is it possible to determine if the index is corrupted? I also 
tried to run this query adding an IGNORE INDEX to skip all the indexes in 
production, but it still took forever. So this makes me think it isn't the 
indexes. I don't really have a good window to run OPTIMIZE in so I just want to 
see if the table or index is corrupted before I go ahead and schedule that 
window. Better yet, is there a more efficient way to write this query?

Any help is greatly appreciated.

Regards,

Max


Max Michaels
Right Media, LLC  |  276 5th Avenue, Suite 605  | New York , NY 10001
212.561.6475 | mmichaels {at} rightmedia.com | www.rightmedia.com 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: BETWEEN

[Max Michaels]

Hello:

I am trying to measure the difference between a single insert statement of
10,000 rows and 10,000 insert statements.

It is easy for me to see the single statement takes about 2 seconds.
However I can come up with no good way to get the total time for individual
statements.  

Can anyone provide a suggestion?  Thanks in advance.


 Try super-smack. It works great for this type of testing.
http://jeremy.zawodny.com/mysql/super-smack/



Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O:  (512) 248-2287
M:  (713) 252-4688



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]