| increase table value [message #628770] |
Fri, 28 November 2014 05:37  |
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
|
Senior Member |
|
|
Hello friends
I have a table of salary sheet it contain 30 columns and about one million records.
So it takes some time to execute records. I used parameters but executing time is very slow. Kindly guide me how I compress table value or increase the table space value.
Regards,
Haider
|
|
|
|
| Re: increase table value [message #628772 is a reply to message #628770] |
Fri, 28 November 2014 05:39  |
 |
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Is the table indexed (especially columns you use in search criteria)?
Make sure you don't execute query (with no parameters) along with the "Query all records" data block property set to "Yes".
[Updated on: Fri, 28 November 2014 05:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
