angel | Powerful Parameter Server for large-scale machine learning | Machine Learning library

The performance of COUNT(*) is not the biggest performance problem in this case. The performance cannot be improved, because your search condition LIKE '%...%' is bound to run a table-scan. It must examine every row in the table anyway, to check if it matches your condition.

Alternatives to make it quicker:

• Match the pattern using fulltext indexing instead of LIKE predicates with wildcards

• Store the count and keep it updated as you add or change data, as the comment above suggests (but you'd need a separate counter for each possible search pattern)

• Get a more powerful computer

• Store less data

While my solution isn't exactly what you describe under Option 2, it is close. We use combineWidgets() to create a grid with a single column and a row height where one graph covers most of the screen height. We squeeze in a link between each widget instance that scrolls the browser window down to show the following graph when clicked.

Let me know if this is working for you. It should be possible to automatically adjust the row size according to the browser window size. Currently, this depends on the browser window height being around 1000px.

I modified your code for the graph creation slightly and wrapped it in a function. This allows us to create 25 different-looking graphs easily. This way testing the resulting HTML file is more fun! What follows the function definition is the code to create a list of HTML objects that we then feed into combineWidgets().

The reason for the error is that there is no 8 and there are 2 12s.

I was not able to figure out how to do this with "visIgraph()" function - but I think I was able to figure out how to generate a random graph (meeting certain conditions: Generating Random Graphs According to Some Conditions) and using the regular "visNetwork()" function and then place a title on this graph:

Not sure to fully understand what you are looking for but:

1. If you want the vertices to be placed randomly and not on a circle, you just need to use the argument layout = "layout_randomly" inside the visIgraph() function.

2. If you want the vertices to be placed randomly and on a circle, you need to use the permute() function and then just add the argument layout = "layout_circle" inside the visIgraph() function.

Please find below a reprex.

Reprex

• Your data

Please find below one possible solution.

Reprex

• Your data

I think if you look through the packages gt and gtsummary, you'll find what you're looking for. For example, this is close to the example you provided as your desired output.

so with this pared down SQL and fake_data: