V4MD request

[info at vallemediatime.com]

Hi Ruslan,

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina-beta at lists.macserve.net>
Sent: Tuesday, June 21, 2005 2:34 PM
Subject: Re: V4MD request


> On 6/21/05 3:19 PM, "info at vallemediatime.com" <info at vallemediatime.com>
> wrote:
> 
> > Right,
> > now, after this new explanation I have better understand some others
> > differences about API-SQL
> > I'm still tried my project with more API calls; at beginning (V2.0.1) it
> > seems to me that API was more slowly... now is better but not how SQL query.
> 
> Hmm. You say that for you API way works slower of SQL ???
> This is not true. 
I say that: "for get data from db and show it in a grid is more slowly... or more probably I use a non optimizing script...
N.B. sprite(n) contains cXtraStringGrid

on ProduceTableData (n, rs, table)
myData = []
fieldCount = table.fieldCount
-- GRID COL HEADERS
sprite(n).colCount = gHeaderList.count
sprite(n).SetRow(0, string(gHeaderList))
-- TABLE ROWS
recCount = rs.itemCount
if recCount > 0 then
iter = rs.makeNewIterator()
if iter.firstItem() then
repeat with i = 1 to recCount
row = []
table.RecId = iter.value
repeat with j = 0 to gHeaderList.count
f = table.field(j)
row[symbol(f.name)] = f.value
sprite(n).SetCellText(j, i, string(f.value))
end repeat
myData[i + 1] = row
iter.nextItem()
-- GRID ROWS
sprite(n).rowCount = myData.count
end repeat
end if
end if 
sprite(n).ColAutoSize()
end

> Aha, may be you repeat mistake and try to work with API way thinking about
> features of SQL way as joing ?
> 
> Remember 2 months ago on beta list was discussion about this.
yes, you have good memory  :-)
 
> If to use API way correctly it can be MANY TIMES faster of SQL way.
 
> 
> > At last,  for my project I hope that API is better way, (I have seen some
> > SQL problems about the case_insensitive and apostrophe... that you know)
> 
> I think there is no real problems. Just you need do steps as using
>     Valentina.EscapeString()
I think that if the string change every time is necessary to detect every time where insert Escape...

> 
> > If you have time in the next days, months? I ask you:
> > "It would appeal to me to have a doc-table that clears just in which
> > circumstances is preferibile to use API or SQL"
> 
> I have told this several times.
I know,
but every a lot is necessary a good ones reassumed  :-)

> Please search beta list for April-May.
done

Thank Paolo


> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
> 
> 
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.7.8/22 - Release Date: 17/06/2005
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20050621/cf95bb02/attachment.html