[PostgreSQL] 수행 시간 데이터 Insert/Select/Delete ( 90,000 entries )

 

수행환경

  - Flask,  psycopg2

 

수행코드

@app.route('/adduser')
def add_user():
	pg_conn = psycopg2.connect(host=HostName, dbname=DatabaseName, user=DatabaseUser, password=DatabasePassword, port=DatabasePort);
	cursor = pg_conn.cursor();
	print( datetime.now() )
	for i in range(90000):
		email_value = str(i)+"love@speech.pe.kr"
		#print(type(email_value))
		cursor.execute("INSERT INTO users(email, enabled, is_changed) VALUES ( '" + email_value+ "', False, False )");
	
	print( datetime.now() )
	pg_conn.commit()
	print("Record(s) Inserted")
	pg_conn.close()
	return "SUCCESS"

 

 

수행결과. :: 90,000개의 데이터 처리 

2023-11-30 13:52:52.242111
2023-11-30 13:57:06.182638
Record(s) Inserted
192.168.50.50 - - [30/Nov/2023 13:57:06] "GET /adduser HTTP/1.1" 200 -
2023-11-30 13:57:29.635902
2023-11-30 13:57:30.011986
192.168.50.50 - - [30/Nov/2023 13:57:30] "GET /alluser HTTP/1.1" 200 -
2023-11-30 13:58:32.326976
2023-11-30 14:07:12.938968
Record(s) Deleted
192.168.50.50 - - [30/Nov/2023 14:07:12] "GET /deluser HTTP/1.1" 200 -

 

즉, 90,000개의 데이터를

추가할 때는 약 4분 14초가 소요되었고 

조회할 때는  0.5초가 소요되었고

삭제할 때는 약 8분 40초가 소요되었습니다.