Search DaniWeb - save and load combobox mysql vb.net

Delete unused MySQL indexes 3 Days Ago by Dani How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application. Re: Delete unused MySQL indexes 3 Days Ago by Dani … blog post](https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/) by the one and only Percona, that says that… Re: Delete unused MySQL indexes 3 Days Ago by Reverend Jim … for removing only unused indexes, I don't know how MySql would be able to determine if an index is used… Re: Delete unused MySQL indexes 3 Days Ago by Dani As some general background, that's the syntax to delete an index, of course, but MySQL knows if an index is used because, well, it's the one that uses it, and it tracks that stuff internally. Now on to my question ... ;) Re: Delete unused MySQL indexes 3 Days Ago by Reverend Jim See [performance-schema-consumer-filtering](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html) Re: Delete unused MySQL indexes 2 Days Ago by Dani …, as well as related ones such as [this](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables….html) and [this](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables… Re: Delete unused MySQL indexes 2 Days Ago by Dani I can see your rationale, but I don't necessarily agree with a separate table in the database for every month. There are much more elegant ways of handling that use case these days, especially in MySQL. You didn't specify how long ago this was. Either way, still hoping a MySQL expert can come along and answer my question here. Re: Delete unused MySQL indexes 2 Days Ago by Reverend Jim >Is that list incomplete or straight-up wrong? I have no way of knowing. If I add a bunch of numbers and get an answer, is it right or wrong? Again, as a guess, if you have enabled the correct flags and let the system run through typical processing, the returned list should be, according to the docs, a list of unused indexes. Worst case … Re: Delete unused MySQL indexes 2 Days Ago by Dani Creating and removing database indexes is very complex and is not a matter of let's throw spaghetti at the wall and see what sticks. When working with big data, loads and loads of thought goes into each and every index. Nearly all indexes can work, but not as well as others might, and having too many indexes on a table can slow down inserts and … Re: Delete unused MySQL indexes 2 Days Ago by Reverend Jim I faced a similar problem when I created and maintained the corporate side databases to mirror the EMS (AGC/SCADA) real time data. One month of data was roughly 300 meg and it was critical that this be available 24x7. Sometimes databases break and it is important to recover them as quickly as possible. Knowing that around 90% of the queries were on… Re: Delete unused MySQL indexes 2 Days Ago by Reverend Jim >You didn't specify how long ago this was. 1998-1999 Re: Are Cross-Platform Apps Slower Than Native? Or Is That Just a Myth in 2025? 6 Days Ago by asadalig In 2025, cross-platform apps aren't inherently slower than native ones—it really depends on how they're built. Modern frameworks like Flutter, React Native, and Kotlin Multiplatform have closed the performance gap significantly. If developers optimize properly, most users won’t notice a difference. However, for extremely high-performance needs like… Re: How to open an Excel Document in VB.NET 3 Weeks Ago by Pelorus_1 A Microsoft Excel document can be opened in VB.NET using the Microsoft.Office.Interop.Excel library. Using Workbooks.Open(), open the workbook, and then display the Excel window. Reference the Excel COM object in your project. Re: How to open an Excel Document in VB.NET 3 Weeks Ago by JamesMichaelm I see it's been a while since you posted, but I'm curious if anyone here has tried using the Open XML SDK instead of Interop or OleDb for reading Excel files. I found it faster and doesn't require Excel to be installed, though it can be more complex for writing. Wondering how others handle big Excel files or ones with tricky formatting? Re: How to open an Excel Document in VB.NET 3 Weeks Ago by PitSterw I've worked on something similar and found that using Microsoft.Office.Interop.Excel lets you open the file and loop through cells easily. Re: Cannot run exe from asp.net 3 Weeks Ago by Reverend Jim >No, Javascript cannot run/start executables on the client machine. Technically correct but there are ways around it. For example, save a file in a special folder on the target computer, which has a folder watch on that folder. The watching task could then trigger a local task. Cannot run exe from asp.net 3 Weeks Ago by lennyli …/web-development/threads/386380/cannot-run-exe-files-in-asp-net-application but still lost in trying to achieve something. I… installed the latest .net framework, and IIS on the latest updated windows 11. I… Re: Cannot run exe from asp.net 2 Weeks Ago by Neil_brown001 … confusion Having two web.config files is normal in ASP.NET apps. One controls the overall app, the other can apply… Re: Cannot run exe from asp.net 2 Weeks Ago by lennyli … > Having two web.config files is normal in ASP.NET apps. One controls the overall app, the other can apply… Re: Cannot run exe from asp.net 3 Weeks Ago by pritaeas > while at the same time run the same exe on the local client pc. Not possible. Re: Cannot run exe from asp.net 3 Weeks Ago by pritaeas No, Javascript cannot run/start executables on the client machine. Re: Cannot run exe from asp.net 3 Weeks Ago by rproffitt I see pritaeas has answered so I'll move to the next stage of the discussion which is to ask what you need in your web site. For example there is an "online notepad" which does some basic notepad work. And there are many screensavers that run from a webpage with an example at whitescreen.online . You can get there. Re: Cannot run exe from asp.net 3 Weeks Ago by lennyli Why does the following code dont run and launch the exe I specify (eg, notepad.exe, or ribbons.scr)? <%@ Language="VBScript" %> <!DOCTYPE html> <html> <Body> <% Dim objShell Dim command Dim result ' Path to the executable command = "C:\… Re: Cannot run exe from asp.net 3 Weeks Ago by pritaeas Are you sure IIS is configured to allow running external scripts? Re: Cannot run exe from asp.net 3 Weeks Ago by lennyli > Are you sure IIS is configured to allow running external scripts? The document folder and asp file has security permission set to ALL rights for 'everyone'. In IIS, under handler mappings for .asp files, under request restriction/access, script was chosen (not execute) for feature permissions, all 'read' 'script' 'execute' are chosen Re: Cannot run exe from asp.net 3 Weeks Ago by lennyli > I see pritaeas has answered so I'll move to the next stage of the discussion which is to ask what you need in your web site. > > For example there is an "online notepad" which does some basic notepad work. And there are many screensavers that run from a webpage with an example at whitescreen.online . > > You can … Re: Cannot run exe from asp.net 3 Weeks Ago by john_111 Let me expand on what rproffitt said, by explaining why. If a webpage could run a program installed on another computer, the entire world wide web would be hacked into tiny pieces and cease to exist. No one would ever use the web, it would be so totally insecure. So web pages are prohibited from running programs on your computer. They can … Re: Cannot run exe from asp.net 3 Weeks Ago by Salem https://xyproblem.info/ * User wants to do X. Sometime later... > My boss just asked me to create a prototype as proof of concept. There is no specific language/tool I must use * User asks for help with Y. Initially asked... > Have a webpage with a button, when pressed, it will launch a webpage that runs a server side exe (eg, … Re: Cannot run exe from asp.net 2 Weeks Ago by gediminas.bukauskas.7 Pritaeas answered the question: normal WEB security settings forbids launching executables on a client machine. The only legal workaround is to create windows service (daemon in Linux environment), install it on client machine and listen for some commands coming from server over WEB sockets. Re: Cannot run exe from asp.net 2 Weeks Ago by lennyli > Pritaeas answered the question: normal WEB security settings forbids launching executables on a client machine. The only legal workaround is to create windows service (daemon in Linux environment), install it on client machine and listen for some commands coming from server over WEB sockets. Sure, I understand, but for my above new …