V4MD request

[Ruslan Zasukhin]

On 6/21/05 5:38 PM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

>>> 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

And how looks SQL ?

-- 
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]