Re: SAP DB instance too slow

Marcin P huet geschriwen:

>If so, please add entries in your hosts file.
>You'll find it in Windows/System32/drivers/etc
>Of course if you have only hosts.sam file you must
>copy it, change it's extension and add an entry like this:
>
>184.02.10.10 myclientPC
>
>That should work.
>I'm not sure if you should add these entries
>on both your client PC (pointing to the server)
>and on the server machine(pointing to the client).
>The last should be enough.
>
>Kind regards,
>Marcin P.
>
>Uzytkownik "red shadow" <[email protected]> napisal w wiadomosci
>news:[email protected]...
>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
>
>
>
>_______________________________________________
>sapdb.general mailing list
>[email protected]
>http://listserv.sap.com/mailman/listinfo/sapdb.general
>  
>
I can't believe that the connection can be speed up if you add all 
clients to the server's host file.
The speed up can can be done by the client I hope so. Otherwise it would 
take a lot of administrative overhead.
I think the problem is during the creation of the connection and relates 
to a  name resolution problem of the DNS there?!
Georg