SAP DB instance too slow
red shadow <[email protected]> Sun, 14 Sep 2003 23:19:13 -0700 (PDT)
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
--0-602943057-1063606753=:70511 Content-Type: text/plain; charset=us-ascii 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 --0-602943057-1063606753=:70511 Content-Type: text/html; charset=us-ascii <DIV>Hi,</DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>I already tried activating indexes but still nothing has changed.</DIV> <DIV> </DIV> <DIV> </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-602943057-1063606753=:70511--