473,325 Members | 2,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

SQL Table

OuTCasT
374 256MB
Can anyone tell me how many columns/rows a table can handle before becoming slow and unusable ?
Apr 3 '08 #1
5 1006
ck9663
2,878 Expert 2GB
I have processed, 15 million rows - by - 100 columns. I just process 380 columns by 60 rows...Everything is working, at least according to the execution time I am required to produce.

-- CK
Apr 3 '08 #2
OuTCasT
374 256MB
I have processed, 15 million rows - by - 100 columns. I just process 380 columns by 60 rows...Everything is working, at least according to the execution time I am required to produce.

-- CK
The reason why I ask is because im busy writing a payroll solution, with several tables, employee, deductions, companyContributions etc and i dont want to make it complicated by joining the tables together and saving the information back....would it be a prblem if i used the one table with all that information in it, obviously there wont be so many rows since i dont think many companies have more than 50 employees. just the columns will be extensive and at a later stage be more than 100 columns.
Is it better to use multiple tables instead of 1 table.
Apr 4 '08 #3
ck9663
2,878 Expert 2GB
Since it's a payroll system, I'd go for the multiple tables. It will also follows the discipline of a Relational Database. Since SQL-Serve can be considered as Relational Database, you can save a lot of time enforcing data integrity and consistency on the database level and not on the apps side.

You also have to remember that you will have monthly or semi-monthly transaction (depending on how payroll is processed), including handling of deductions.

-- CK
Apr 4 '08 #4
OuTCasT
374 256MB
Since it's a payroll system, I'd go for the multiple tables. It will also follows the discipline of a Relational Database. Since SQL-Serve can be considered as Relational Database, you can save a lot of time enforcing data integrity and consistency on the database level and not on the apps side.

You also have to remember that you will have monthly or semi-monthly transaction (depending on how payroll is processed), including handling of deductions.

-- CK
Well its only monthly transactions. there will be a table for earnings and deductions, most of the screens will use information from these 2 tables.

this is fairly easy. What i would like to knw is the month end procedure that will update all the tables with the recent data AND insert the Month data into a MonthEnd table for record purposes.
Is it possible to create a .dll to handle these procedures ??
Apr 4 '08 #5
ck9663
2,878 Expert 2GB
If all data are in sql-server, I'd recommend stored proc.

-- CK
Apr 4 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Gaz | last post by:
Hi, I need to have a table nested within another table. The tables are alongside each other visually speaking, and the nested table (on the right) can vary in size. My problem is that when the...
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
3
by: Terrence Brannon | last post by:
I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before CREATE TABLE, so here are the ERRORS emitted when...
4
by: maricel | last post by:
I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY
4
by: Simone Battagliero | last post by:
I wrote a program which inserts and finds elements in an hash table. Each element of the table is a dinamic list, which holds all elements having the same hash value (calculated by an int...
117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
76
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...
7
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the...
5
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big...
5
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.