BIT Database Indexer Script - Adobe ColdFusion Version
BIT Database indexer admin interface uses your selected data source and provides details on your database.
The Index status page lists table name, index name, fragmented percent and has a rebuild link.
When the rebuild link is clicked, the index is rebuilt by MS SQL Script.
This makes managing your database fragmentation level easy!
The rebuild process is also included as a custom tag tag can be configured to run in the background of any page you select on your web site.
The script will email your address on file with updates as it has completed rebuilds.
What is Level 1 AI?
Level 1 AI is also known as Narrow AI. This Artificial Intelligence is designed and coded to perform a specific task. This is also known as a "narrow range of tasks".
Narrow AI system are designed for a specific purpose. These Narrow systems performs their designated tasks to make life easier.
Like an AI, the Bit Indexer helps manage your database index fragmentation when your parameters are met.
The table size page provides a simple list of tables in your selected database. With row count, and size of each table this provides a easy way to see details on your database.
The database table and index list shows details about your database tables.
- Total number of tables found
- Number of tables with indexes
- Number of tables with multiple indexes
- Number of tables with no index
This page also lets you go into details about each table to see the columns ad field types.
The database action logs show all updates completed using the Bit AI database index script. Logs will show here if the action was taken in the admin section, or if it was performed by the AI script during a background rebuild.
This will also show the tables that had the most rebuilds, so you can check the table and related code to see if any process is causing the fragmentation.
Designed and tested to work with Adobe ColdFusion 2021 and later, this script will make managing your database index fragmentation easy.
The above screen shots show the simple admin interface that can be set up as its own site, or included in your own Adobe ColdFusion site's admin section.
This also includes a custom tag so you can include the script to run in the back ground and send an email update when a preset number of rebuilds have been completed.
The code is unencrypted and licensed for use on your site, per the agreement you purchase.
The Bit database index script has versions under development in ASP.net and Ruby on Rails.
If you are interested in ASP.net, Ruby or another version, please contact Us and let us know.