Às 08:13 de 24/02/20, Константин Комков escreveu:
*Villas*, I can explain why I need to delete many records. I have template of
timetable (example upper in my post). There is templates for each group for
each faculty in university. ~40 groups = 40 templates for each faculty.
When I do timetable
It seems this is a complex routine and I can only talk in general terms.
Perhaps you do need a temporary table, and it should not be a problem to
create one.
However, it still seems strange that you think the problem might be the
webserver rather than the DB.
I do not know how to help with you
*Villas*, I can explain why I need to delete many records. I have template
of timetable (example upper in my post). There is templates for each group
for each faculty in university. ~40 groups = 40 templates for each faculty.
When I do timetable I need to do next operations:
- Select all acti
You do not explain why you would need to delete and then insert 25K records
to prepare a timetable.
It seems that you are creating a temporary table and that is seldom the
correct approach.
- If all the data is already available in the tables, then you should
be able to write SQL whi
I can't solve that problem still. I have additional information also.
Maximum count of unique rows for insert can be 25000, and before I need to
delete maximum 25000 rows in database. Seems like it's IIS settings,
becouse if I work with 5000 unique rows and Rocket server on local I don't
have e
Hello!
I guess that your mean by importing, reading data from the database. if so,
without any further information I can only suggest the following workaround:
- Try reading not the whole data (all rows) at once. Maybe you can
select part of it by the selecting the different faculties by
6 matches
Mail list logo
