Setup note: https://python.langchain.com/docs/modules/agents/agent_types/openai_functions_agent
Month: April 2024
SQL tricks
learned tricks: Following SQL clause impact query performance: 1. Parses JSON textby OPENJSON() syntax 2. Timestamp format Observed query speed [test3] >>[test1] 3. Update in SQL process speed is lower than insert with specified column new constant value 4. Prefer to use NOT NULL in create schema. NULL cost extra space or other unexpected outcome… Continue reading SQL tricks