[EMAIL PROTECTED] wrote: > Hi Holger/Christian, > > I thought of the cache issue, and therefore ran the command > numerous times > from SQL Studio. The first time is much longer for the > Count(ID) and then > it drops to 4.5 seconds consistantly thereafter. The time > for count(*) is > not much different the first time, and then remains at 0.1 seconds. > > How can this be?!!! > > Cheers, > > David
Could you please provide a default vtrace of both cases? For information about how to create a vtrace see http://sapdb.2scale.net/moin.cgi/VTrace. Thanks in advance. Best regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
