Re: SAP DB instance too slow
red shadow <[email protected]> Mon, 15 Sep 2003 21:20:18 -0700 (PDT)
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
--0-1817989551-1063686018=:58374 Content-Type: text/plain; charset=us-ascii I do not have a DNS. I'm just using a peer-to-peer connection here. I created the database with the script included in the SAP DB package. Thanks. Marcin P <[email protected]> wrote: Hi! Could you tell us what is taking so long? I think that you've got problem with connecting to your instance and after that your query is executed very fast - check if you have your server registered in your DNS. (look in the archives of this list). Regards, Marcin Uzytkownik "red shadow" napisal w wiadomosci news:[email protected]... Hi, I have tried SAP DB for use in Windows OS. Using Visual Basic as the front end. While querying from sap db I took almost more than 40 seconds waiting for 8 records coming from just one table with 5 columns. My SAP DB database size is initialized as 20MB. I tried the same with SQL Server which gives me the result of less than one second, this is the same in Access. I already tried activating indexes but still nothing has changed. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software _______________________________________________ sapdb.general mailing list [email protected] http://listserv.sap.com/mailman/listinfo/sapdb.general --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software --0-1817989551-1063686018=:58374 Content-Type: text/html; charset=us-ascii <DIV> <DIV>I do not have a DNS. I'm just using a peer-to-peer connection here.</DIV> <DIV> </DIV> <DIV>I created the database with the script included in the SAP DB package. <BR></DIV> <DIV>Thanks.</DIV> <DIV><BR><B><I>Marcin P <[email protected]></I></B> wrote: </DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hi!<BR>Could you tell us what is taking so long?<BR>I think that you've got problem with connecting<BR>to your instance and after that your query is<BR>executed very fast - check if you have your server<BR>registered in your DNS. (look in the archives of this list).<BR>Regards,<BR>Marcin<BR>Uzytkownik "red shadow" <[email protected]>napisal w wiadomosci<BR>news:[email protected]...<BR>Hi,<BR><BR>I have tried SAP DB for use in Windows OS. Using Visual Basic as the front<BR>end. While querying from sap db I took almost more than 40 seconds waiting<BR>for 8 records coming from just one table with 5 columns.<BR><BR>My SAP DB database size is initialized as 20MB. I tried the same with SQL<BR>Server which gives me the result of less than one second, this is the same<BR>in Access.<BR><BR>I already tried activating indexes but still nothing has changed.<BR><BR><BR><BR><BR>Do you Yahoo!?<BR>Yahoo! SiteBuilder - Free, easy-to-use web site design software<BR><BR><BR><BR>_______________________________________________<BR>sapdb.general mailing list<BR>[email protected]<BR>http://listserv.sap.com/mailman/listinfo/sapdb.general</BLOCKQUOTE></DIV><p><hr SIZE=1> Do you Yahoo!?<br> <a href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo! SiteBuilder</a> - Free, easy-to-use web site design software --0-1817989551-1063686018=:58374--