YellowLab Posted July 10, 2008 Share Posted July 10, 2008 I was surfing around for some specific information regarding SQLite and found this:http://web.utk.edu/~jplyon/sqlite/SQLite_o...zation_FAQ.htmlBasically, it is a FAQ on optimizing SQLite procedures. It seems to have been written for a late version 2 of the SQLite library and isn't complete; however, the information contained should carry over to the current version.I found many of the ideas presented as "Duh" but there were a few things I hadn't thought about and thought others here could benefit from the document.Bob You can't see a rainbow without first experiencing the rain. Link to comment Share on other sites More sharing options...
ptrex Posted July 11, 2008 Share Posted July 11, 2008 @YellowLabNice to bring in this information.But it would be better to post it in the SQLite thread so people will find it easier.SQLIte in AU3regardsptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now