Hi Dusan > -----Original Message----- > From: Dusan Kolesar [mailto:[EMAIL PROTECTED] > Sent: Montag, 12. Januar 2004 14:58 > To: [EMAIL PROTECTED] > Subject: Performance diference > > > Hello, > > I have table with next structure: > CREATE TABLE "ADMIN"."MAPSERVER" > ( > "ID" Integer NOT NULL DEFAULT SERIAL (1), > "TSTAMP" Timestamp, > "TOWNDESCR" Varchar (50) ASCII, > "IMAGE" Long BYTE, > "IMAGELEN" Integer, > PRIMARY KEY ("ID") > ) > > When I insert row with image bigger than 50kB it takes more > than 1 minute. > When I insert smaller image then it takes aprox. 1 second. > > What can be reason of this performance diference?
I don't know, but a driver manager trace could help. http://sapdb.2scale.net/moin.cgi/ODBCTrace Regards Thomas ---------------------------------------------- Dr. Thomas Kötter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
