SAP DB too slow
"Edson Carlos Ericksson Richter" <[email protected]> Mon, 15 Sep 2003 10:37:44 -0300
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. ------=_NextPart_000_00EA_01C37B75.6576A410 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know recent releases of SapDB has an option to disable dns (name = lookup) resolution in Win32 plataform. What is the parameter, and where it = should be put... In registry? In service command line? Thanks for any tips, Edson Richter > ----- Original Message -----=20 > From: Thomas Cataldo > To: red shadow > Cc: [email protected] > Sent: Monday, September 15, 2003 6:24 AM > Subject: Re: SAP DB too slow >=20 >=20 > On Mon, 2003-09-15 at 09:12, red shadow wrote: > > Hi, > > > > I installed SAP DB and tried with my visual basic program. > > Using MS SQL I used to access a single table with only 10 rows and 3 > > columns for less than a second, but with SAP DB I took about more = than > > 30 seconds to retrieve these data. > > > > What should I do to speed up sap db database. >=20 > Martin already gave you the answer. The name resolution on your = database > server is wrong. You're getting resolution timeouts. >=20 > > > > > > = ______________________________________________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site design software >=20 > _______________________________________________ > sapdb.general mailing list > [email protected] > http://listserv.sap.com/mailman/listinfo/sapdb.general >=20 >=20 > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.518 / Virus Database: 316 - Release Date: 11/9/2003 >=20 >=20 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/9/2003 ------=_NextPart_000_00EA_01C37B75.6576A410 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>I know recent releases of SapDB has an option to disable dns (name=20 lookup)<BR>resolution in Win32 plataform. What is the parameter, and = where it=20 should be<BR>put... In registry? In service command = line?<BR><BR><BR>Thanks for=20 any tips,<BR><BR>Edson Richter<BR><BR>> ----- Original Message ----- = <BR>>=20 From: Thomas Cataldo<BR>> To: red shadow<BR>> Cc: <A=20 href=3D"mailto:[email protected]">[email protected]= .com</A><BR>>=20 Sent: Monday, September 15, 2003 6:24 AM<BR>> Subject: Re: SAP DB too = slow<BR>> <BR>> <BR>> On Mon, 2003-09-15 at 09:12, red shadow=20 wrote:<BR>> > Hi,<BR>> ><BR>> > I installed SAP DB and = tried=20 with my visual basic program.<BR>> > Using MS SQL I used to access = a=20 single table with only 10 rows and 3<BR>> > columns for less than = a=20 second, but with SAP DB I took about more than<BR>> > 30 seconds = to=20 retrieve these data.<BR>> ><BR>> > What should I do to speed = up sap=20 db database.<BR>> <BR>> Martin already gave you the answer. The = name=20 resolution on your database<BR>> server is wrong. You're getting = resolution=20 timeouts.<BR>> <BR>> ><BR>> ><BR>> >=20 ______________________________________________________________________<BR= >>=20 > Do you Yahoo!?<BR>> > Yahoo! SiteBuilder - Free, easy-to-use = web site=20 design software<BR>> <BR>>=20 _______________________________________________<BR>> sapdb.general = mailing=20 list<BR>> <A=20 href=3D"mailto:[email protected]">[email protected]= .com</A><BR>>=20 <A=20 href=3D"http://listserv.sap.com/mailman/listinfo/sapdb.general">http://li= stserv.sap.com/mailman/listinfo/sapdb.general</A><BR>>=20 <BR>> <BR>> ---<BR>> Outgoing mail is certified Virus = Free.<BR>>=20 Checked by AVG anti-virus system (<A=20 href=3D"http://www.grisoft.com">http://www.grisoft.com</A>).<BR>> = Version:=20 6.0.518 / Virus Database: 316 - Release Date: 11/9/2003<BR>> <BR>> = <BR><BR></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2><BR>---<BR>Outgoing mail is certified = Virus=20 Free.<BR>Checked by AVG anti-virus system (<A=20 href=3D"http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: = 6.0.518 /=20 Virus Database: 316 - Release Date: 11/9/2003</FONT></DIV></BODY></HTML> ------=_NextPart_000_00EA_01C37B75.6576A410--