 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Bpk. Adi Wira Kusuma
Guest
|
 Posted: Sun Apr 08, 2007 7:23 am Post subject: i have any problems? |
 |
|
I use win 2000 sever as server, xp or win 98 as clients. If I set dsn each
xp client, why can it not connect server (sql server)? But it can see
sharing folder on server?
=====================================
I have a table transaction. it has a lot of records which contains data for
5 years. How to make the best performance access?
1. Do I need to devide the data per year into new table?
2. Or Do I just make a view or function to get the data per year?
3. Or ...... what?
oh yeach.......... I still confuse about the database file (*.mdf). I sure
that the file can be broken. So if the database file (*.mdf) is broken, are
all table also broken? May only some tables in a database file (*.mdf) be
broken? |
|
| Back to top |
|
 |
Andrew V. Fionik
Guest
|
| Posted: Mon Apr 09, 2007 9:08 pm Post subject: Re: i have any problems? |
|
|
Hello, Bpk.!
You wrote on Sun, 8 Apr 2007 09:23:05 +0700:
BAW> I use win 2000 sever as server, xp or win 98 as clients. If I set dsn
BAW> each xp client, why can it not connect server (sql server)? But it
BAW> can see sharing folder on server?
This means that probably your DSN settings is not correct.
BAW> I have a table transaction. it has a lot of records which contains
BAW> data for 5 years. How to make the best performance access?
BAW> 1. Do I need to devide the data per year into new table?
BAW> 2. Or Do I just make a view or function to get the data per year?
BAW> 3. Or ...... what?
Achieving optimal perfomance is complex task. There are many ways to do this
for each specific database. But there are few common things applied to any
database. Make sure that you have indexes for fields which participate in
the "where" clauses. Make sure that tables in your database is well
normalized. Make sure that your applications select only neccessary data
from database, and do it only when neccessary.
Additionally you can split your large table to two parts. One part is recent
records for recent amount of time and second part all other records -
archive. Ensure that your day to day queries use only records from the first
table.
---
Andrew V. Fionik. SQL Maestro Group, http://www.sqlmaestro.com
Database administration, management and development tools for
Oracle, MS SQL Server, PostgreSQL, Firebird, MySQL, MaxDB, SQLite. |
|
| Back to top |
|
|
newsgroups.borland.com
Guest
|
| Posted: Tue Apr 10, 2007 5:55 am Post subject: Re: i have any problems? |
|
|
| Quote: | 1. Do I need to devide the data per year into new table?
|
No
| Quote: | 2. Or Do I just make a view or function to get the data per year?
|
No
| Quote: | 3. Or ...... what?
|
Put a field in the table for year (or date), and put it in an index.
Oliver Townshend |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
