Hi.

First of all, the following is my MySQL database table structure.

I have imported 500K data to this table make it up to 1.7GB and cause to slow search perfomance. 

May i know anyway to improve it?

CREATE TABLE  `tuote_general` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parentCatID` int(10) unsigned NOT NULL,
  `childCatID` int(10) unsigned NOT NULL,
  `subchildCatID` int(10) unsigned NOT NULL,
  `merchantID` char(10) NOT NULL,
  `branchID` char(10) NOT NULL,
  `distributorID` char(255) NOT NULL,
  `PID` char(255) NOT NULL,
  `CID` char(10) NOT NULL,
  `refID` char(50) NOT NULL,
  `product_group` char(50) DEFAULT NULL,
  `product_type` char(50) NOT NULL,
  `product_mode` char(50) NOT NULL,
  `service_group` char(50) NOT NULL,
  `service_type` char(50) NOT NULL,
  `delivery_group` char(50) NOT NULL,
  `delivery_type` char(50) NOT NULL,
  `scheduleAt` datetime NOT NULL,
  `scheduleEnd` datetime NOT NULL,
  `payment` char(50) NOT NULL,
  `access` char(255) NOT NULL,
  `priority` char(5) NOT NULL,
  `status` char(10) NOT NULL,
  `created_by` char(50) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_by` char(50) NOT NULL,
  `modified_date` datetime NOT NULL,
  `authenticated_by` char(50) NOT NULL,
  `authenticated_date` datetime NOT NULL,
  `CODE` char(50) NOT NULL,
  `serial_no` char(50) NOT NULL,
  `pin_code` char(10) NOT NULL,
  `name` char(255) NOT NULL,
  `point` decimal(10,2) NOT NULL,
  `remark` text NOT NULL,
  `review_status` char(50) NOT NULL,
  `review_message` text NOT NULL,
  `award_status` char(50) NOT NULL,
  `award_source` char(255) NOT NULL,
  PRIMARY KEY (`ID`,`parentCatID`,`childCatID`,`subchildCatID`,`merchantID`,`branchID`,`distributorID`,`CID`,`refID`,`PID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8;

Meanwhile, I got this error message: system.outofmemoryexception was thrown when i try to export gridview to excel file (50K data)

My reference URL to export gridview to excel file.

Export GridView to Excel without losing gridlines in Excel file in ASP.Net

Any suggestion to improve my work?