SQLITE Slow !!!

[roti]

hi everyone

i have just used Customer application with sqlite
when i load large DB File it takes long time to view
how could i reduce the time of viewing ?

Thanks in advance

[bule]

It is not a SQLite problem. It is a performance issue with ListBox/ComboBox in AutoPlay Media Studio when filled with more than 1000 entires. You might gain some performance with ListBox.SetUpdate(false) before updating, but not much...

Try using DataGrid instead... it is much faster, all through there is no OnFocus and OnKey functionality with DataGrid.

[bule]

Can you show us the code you are using to populate data on screen?

[azmanar]

Hi,

I think ...Listbox Actions should come with Callback Function. At least a Progress Bar can be shown during List.Add or List.Insert

[bule]

Indeed... but that will render the process even slower. :(

[Worm]

I just posted an example to the examples forum that will fill a listbox much quicker. As soon as IR approves it, it should show up.

Here's the code behind it.

function ListBoxAddItem(oListBox, sItem)
	DLL.CallFunction(_SystemFolder.."\\User32.dll", "SendMessageA", ListBox.GetProperties(oListBox).WindowHandle..",384,0,\""..sItem.."\"", DLL_RETURN_TYPE_LONG, DLL_CALL_STDCALL)
end

for n=1, 5000 do
	ListBoxAddItem("ListBox1", "Item"..n)
end

[azmanar]

Thanks Worm...

[Worm]

Same deal for Combo too

function ComboAddItem(oCombo, sItem)
	DLL.CallFunction(_SystemFolder.."\\User32.dll", "SendMessageA", ComboBox.GetProperties(oCombo).WindowHandle..",323,0,\""..sItem.."\"", DLL_RETURN_TYPE_LONG, DLL_CALL_STDCALL)
end

for n=1, 5000 do
	ComboAddItem("ComboBox1", "Item"..n)
end

[Worm]

Use Desmond's method in this thread

http://www.indigorose.com/forums/showpost.php?p=94507&postcount=2

Much better, and it actually works, unlike mine :o

[bule]

Worm, you are passing Name, but not Data as well...

With this Desmond's method.. while still faster, try adding 30000 items;
It will not take 6 times much time (5000×6), but somewhere arount 22 times...

[Worm]

The data field is a tricky one as the listbox itself will only hold a LONG for data. IR is doing us a favor by making it so we can use strings or numerics. I could set the data, but it would have to be numeric with this method. One work around would be to use an invisible Listbox with the data items. But, all of this is a mute point as the items once added, can't be selected. They show in the listbox alright, but...

Sorry, thought I'd stumbled onto something.

[azmanar]

Hi,

In Desmond's method, it does add some speed with the loop.

But by using ListBox.update, the latest added info in the LB containing hundreds of items will be buried deep down. Therefore will not get selected.

[roti]

It is not a SQLite problem. It is a performance issue with ListBox/ComboBox in AutoPlay Media Studio when filled with more than 1000 entires. You might gain some performance with ListBox.SetUpdate(false) before updating, but not much...

Try using DataGrid instead... it is much faster, all through there is no OnFocus and OnKey functionality with DataGrid.

where can i get DataGrid

[roti]

Thanks bule , Azmanar , Worm
the Problem is with generating the HTML report
it takes a very long time to generate the report

[bule]

How do you generate it? (what method)