Created: 3 years ago Author: Md Mahfoozur Rahman
query is much lesser than earlier now. yes, there are still some unwanted query as well because of database wrong organized. like as an example, networks statistic data are in saved in descriptive_stats but for few of my network stats are not there. but if we try to find on nodes and edges table then we are getting data, so this is type of unwanted query is still there.
Rene, 2:50 AM
okay we need to start planning to improve DB
i think rahul looked at it once
anyways we can make homepage static
jahidul, 2:50 AM
we also need remove duplicates as well
Rene, 2:51 AM
ok
7:50 PM
query is much lesser than earlier now. yes, there are still some unwanted query as well because of database wrong organized. like as an example, networks statistic data are in saved in descriptive_stats but for few of my network stats are not there. but if we try to find on nodes and edges table then we are getting data, so this is type of unwanted query is still there.
jahidul islam, Tuesday at 2:50 AM
Can you share the urls of network that you feel dont have data on descriptive stat.. for empty network without nodes it wont save in descritive stat tbl.. also network having any error while saving data.. wont save into descriptive stat tbl.. so I need to check it..
12:00 AM
Also disable this page pages/new_demo_project.php for preventing insertion in projects tbl for demo network creation. It seems in db project tbl there are still empty rows getting created.. @jahidul
3:45 AM
@jahidul
Md Mahfoozur Rahman, Saturday at 12:00 AM
just to add to this comment.. I have commented out code page pages/new_demo_project.php in this page and pushed it to bitbuclet.. for the prevention of auto insertion in project tbl..
I will add the captcha later..
Rene, 3:46 AM
sounds good thnka
thanks
can display:hide it in the UI as well
3:48 AM
yes can be done.. but that remote auto script recognises the demo url link.. already.. thats the problem.. so we need to eventually add captcha here..
I am surprised that even after changing domain from netsci to atomstoeve that remote server did not stop doing hitting that url..
Rene, 3:49 AM
agree
is it us? lol
how the hell did someone find it
hm i wonder if there are analytics of country
probably remote though so doesn't even matter
3:51 AM
lol.. its definitely not us.. may be some hacker.. trying to hack.. they have tools.. to find these public urls and damange sites by doing unnecessary hits..
jahidul, 3:52 AM
Can you share the urls of network that you feel dont have data on descriptive stat.. for empty network without nodes it wont save in descritive stat tbl.. also network having any error while saving data.. wont save into descriptive stat tbl.. so I need to check it..
Md Mahfoozur Rahman, Friday at 7:50 PM
i have logged in with rene3 user. all the networks of favorites of that user does not have data on that table, you can see the network of this id -> 1487723384. i think, we should save data if any network does not have nodes or edge as well.
Rene, 3:52 AM
ok
hm
are we ssaving all these demo networks?
3:56 AM
well I need to check.. iif I remember.. f there is no node in network and we try to calculate descriptive states and save.. perhaps error was occuring.. thats why I think I was not saving stats for empty networks... I will check again..
besides for saving of descriptive stat user must come to network page.. also
Rene, 11:19 PM
ok
anyways we need to keep reanalyzing the code
Topic: Jahidul Topic Creator: Md Mahfoozur Rahman