java - JavaFx Tableview speed and sorting in Sql application -


i working on small, toy application expand knowledge java javafx , sql. have mysql server in local network, able communicate , simple tableview can populated, sorted ... etc. data has shown user, no editing. nice , clean.

the problems:

  • there around 170 000 rows 10 col., chars, display, seems rather hard in reasonable time. query done during startup , take around 1 1/2 min before can see table.

  • also memory footprint enormous, application without populated tableview around 70 mb, data has 600-700 mb (the xml file used populate mysql 70 mb in size ... ) !

  • sorting slow, using stringproperty should give boost according to: javafx tableview sort slow how improve sort speed in java swing (if understood correctly) custom sort, did not try far.

my thoughts:

similar application design mobile, think adapter-pattern can fix these problems. hence, create oberservablelist correct size of elements, populate limit of rows in beginning. when scrolling done (scroll wheel) list has updated new elements in advance via sql-queries. should give me performance boost first problem. nice idea going if user going scroll done via scrollbar(click , drag down), skip entries, need information give user feedback scroll to. how fix ?

for sorting, use sql sorting methods, each sort performed on sql server , new oberservablelist created. before, amount of data loaded in first query.

if approach effect memory footprint, not sure.

your opinion: ideas reasonable , do-able in java, javafx ? love hear ideas these problems.

thank you.

i found out jvx capable of providing lazy-loading function. should trick


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more