Skip to content

Instantly share code, notes, and snippets.

View grigory51's full-sized avatar
✌️
Бодрячком! Все возможно!

Grigory Ozhegov grigory51

✌️
Бодрячком! Все возможно!
View GitHub Profile
@grigory51
grigory51 / ipv6-httpd.py
Last active April 27, 2022 09:23 — forked from akorobov/ipv6-httpd.py
quick ipv6 http server using python's SimpleHttpServer
import socket
from BaseHTTPServer import HTTPServer
from SimpleHTTPServer import SimpleHTTPRequestHandler
class HTTPServerV6(HTTPServer):
address_family = socket.AF_INET6
def main():
server = HTTPServerV6(('::', 8081), SimpleHTTPRequestHandler)
server.serve_forever()
@grigory51
grigory51 / indexes_to_add.sql
Last active July 6, 2024 11:37 — forked from mitio/indexes_to_add.sql
OpenCart SQL profiler and indexes for improved speed and page load time
ALTER TABLE `oc_product_to_store` ADD INDEX(`store_id`);
ALTER TABLE `oc_product_description` ADD INDEX(`language_id`);
ALTER TABLE `oc_category_path` ADD INDEX(`path_id`, `category_id`);
ALTER TABLE `oc_category_path` ADD INDEX(`category_id`, `path_id`);
SET sql_mode = 'STRICT_TRANS_TABLES'; -- mysql 5.7
ALTER TABLE `oc_product` ADD INDEX(`status`);
-- Add these to speed up OpenCart
ALTER TABLE `oc_product` ADD INDEX(`date_available`, `status`);